| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto fill the blank with value
how can i auto fill the blankcell with a value till the next blank..den auto
fill again with another values..mean in this case i wan the value "A" to fill up all the blank cell below it and stop on top of the value"B" den auto fill with "b" values to nxt blank n cont... eg.. col a col b A 1 2 3 B 2 3 C 4 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto fill the blank with value
Say your list is from A2 to A100 with some values and some blanks.
First highlight the range a2 to A100 Then Edit/Goto/Special blanks. Then enter the following formula =if(A1<A2,A2,A1) and hit control-Enter (Control Enter merely fills the formula in all selected cells) "violet" wrote: how can i auto fill the blankcell with a value till the next blank..den auto fill again with another values..mean in this case i wan the value "A" to fill up all the blank cell below it and stop on top of the value"B" den auto fill with "b" values to nxt blank n cont... eg.. col a col b A 1 2 3 B 2 3 C 4 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-update Fill Series in column that has randomly spaced blank c | Excel Discussion (Misc queries) | |||
| Auto fill values with a blank row formatting between entries | Excel Discussion (Misc queries) | |||
| Auto Fill Blank Cells | Excel Discussion (Misc queries) | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| blank cells with auto fill in excel | Excel Worksheet Functions | |||
Linear Mode
