List Numbering in Excel


Posted by celeste on November 23, 2001 6:17 PM

I have a survey that I am sending out and I need to number it - it has been going through numerous revisions and it has become very tedious to continuously re-number it by hand. I need a way to number the document and have it update itself when questions are moved, deleted or inserted.

Basically the questions are numbered Q1. Q2. etc.

Each question takes up multiple lines in Excel. I did find this formula on the web

=IF(B1<>"",COUNTA($B$1:B1)&".","")

but it isn't working AND it doesn't take into account that each question has multiple lines in Excel. Can you help me figure out a way to save myself hours of time re-numbering?

HELP!

Celeste Smith



Posted by Luis B. on November 23, 2001 6:25 PM

Have you tried to state your IF function in terms of the first characacter of each line. If it is a capital letter, then number, if not do not. Granted there could be cases that the first letter is capitalized, but this should take you almost there.