[Sampath Shambu]

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

[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)


"Sampath Shambu" <Sampath wrote in message
...
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

[Matthew[_2_]]

On 4 Jul, 06:45, "Peo Sjoblom"
wrote:
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)

"Sampath Shambu" <Sampath wrote in ...

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


Peo,

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

Matthew