10s! John Bundy, was interesting to know abt the formula
however
along the alternate row that was supposed to be blank, it shows some data
like 0-Jan

example:

A B C

1 01-May

2 0-Jan

3 02-May

4 0-Jan

able to use the formula, =if(b2="",b1,b2)
how can i remove the 0-Jan to have the alternate row with a Blank?

thanks for your great help!!

thanks community as well
--
oldLearner57


"John Bundy" wrote:

The fastest way is to insert a column, then put in the following formula and
copy it down.
=IF(B2="",B1,B2)

We are just say that if the cell is blank, use the value in the cell above
it, if not then leave it alone.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"oldLearner57" wrote:

hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57