Sequencing numbers in a formula.

**sleazyfish** · 06-09-2009, 05:40 AM

I'm trying to sequence some information in column(E). However if a cell is blank(B) then a blank cell appears and the sequenced number is placed in the following row of the column. e.g:

pear 1
apple 2
banana 3
mango 4

pear 1
apple 2

mango 3

Thanks in advance

**sleazyfish** · 06-09-2009, 06:01 AM

Doesn't matter because i solved it myself.

Placed in column E and then copied down:

=IF(ISNA(IF(B2="","",VLOOKUP(MAX(E$1:E1),E$1:E1,1)+1)),1,IF(B2="","",VLOOKUP(MAX(E$1:E1),E$1:E1,1)+1))

Great forum though. It's been a great help to me over the past year.