How to fill a blank cell down to a filled cell

Posted to microsoft.public.excel.worksheet.functions

Sampath Shambu Sampath Shambu is offline

external usenet poster

Posts: 1

How to fill a blank cell down to a filled cell

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro Request: Fill in empty cells with previous Filled cell in column	Artis	Excel Worksheet Functions	2	June 25th 07 08:30 PM
Fill cell that is blank	Slashman	Excel Worksheet Functions	7	August 28th 06 01:30 AM
How do I auto fill long col. filling blanks with last filled cell	MBBeginner	Excel Discussion (Misc queries)	3	January 15th 06 12:44 AM
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH	CHARI	Excel Worksheet Functions	4	August 30th 05 12:54 AM
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH	×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ	Excel Worksheet Functions	0	August 29th 05 09:55 PM

All times are GMT +1. The time now is 05:33 PM.

Menu

About Us