How to fill a blank cell down to a filled cell

[Guest]

How to fill a blank cell down to a filled cell above that blank cell.
For example if A1 has Sampath and A4 has Shyla, I would like to get A2 & A3
with the same value in A1, i.e., Sampath.

Can somone who know the formula for this, please mail the same to
(e-mail address removed)

 

[Peo Sjoblom]

Select the range in question, press F5, click special and select blanks and
press enter or click OK
type an equal sign =
hit the up arrow and press ctrl + enter

Voila!


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Matthew]

Select the range in question, press F5, click special and select blanks and
press enter or click OK
type an equal sign =
hit the up arrow and press ctrl + enter

Voila!

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutionswww.nwexcelsolutions.com
(Remove ^^ from email)

Peo,

That goes under the heading I wish I knew that years ago !!! Thanks.

Matthew