Adding sequential numbers to Column A if Column B has text

[computer12345]

Capture.JPG

Hi! Attached is the excel that I'm currently working on. Is there a way to number the companies in Column B? (i.e. A2 will return 1.01, A7 will return 1.02, A11 will return 1.03). Would be great if there is a quick method to do this as it's quite tedious to manual key in the number (it has 100+ companies).

Thanks for the help!

[Ace_XL]

Type in 1.01 in Cell A2

Then in Cell A3 use
=IF(ISTEXT(B3),MAX(A$2:A2)+0.01,"")

Copy down as far as required

Make sure that dates in Column B are actually dates and not just text.

[computer12345]

Thanks for the reply!

Ace_XL: I tried using your formula but numbers appeared regardless of text or date (i.e. A2 to A4, A7 to A8, A11 to A19). Tried changing the cells to dates but it still didn't work. Maybe I did something wrong.

However, i managed to figure out

Please Login or Register  to view this content.

seems to work well for me, so thank you for pointing me in the right direction!