Automating List Numbering in Excel

[Guest_imported]

I want to write VBA to number lists for me in Excel 97.

Column B contains a number of lists, separated by empty cells. Is it possible to automatically number these lists in Column A, starting from scratch after every blank cell?

The lists are of varying lengths.

Also, is it possible to do this with letters, (eg. a, b, c……)?

 

[JVFriederick]

Assume your data list begins with row 2. Add the following equation to cell A2.

=IF(ISBLANK(B2),"",N(A1)+1)

Copy this formula down for all records.

Once you have created a counter, you can modify the equation to append A or B or C and so on.

 

[Guest_imported]

Many thanks, thats exactly what I'm looking for. However you're giving me more credit than I deserve, how do you substitute numbers with letters?

 

[JVFriederick]

I meant adding A or B or C after the lists have been numbered like so :
A1
A2
A3
A4

B1
B2
B3

To add A in front of the numbers :
+"A"&TEXT(B2,"000&quot

I don't know how to generate a lettered list.

 

[Guest_imported]

I've managed to do it using =(CHAR(CODE(A1)+1)).

Thanks for your help.