Auto-fill the selected cells without using macro

S

sachi.b

Hi,

I have selected few cells in the same column. Say A2, A5, A9, A11, A16
and A20 in random order.

I want to fill the series in these selected cells.

Like:

A2 1
A5 2
A9 3
A11 4
A16 5
A20 6
.... .
.... .
.... .


Can anyone please help me !!!

Thanks in advance,
Sachi
 
B

Big Chris

AP,

I'm assuming that there is some other data that you want to put
number alongside.....saying in colum B, but only where column B is no
blank?

If so, how about this - =IF(B28="","",MAX(A$2:A27)+1)

It's basically saying "If the corresponding cell in column B is blan
then leave the cell in A blank. But if the cell in B is not blank the
insert a number which is equal to the maximum number in the colum
above + 1".

Hope this gives you what you were after.

Regards,

Chri
 
Top