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
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?