Posted to microsoft.public.excel.worksheet.functions
|
|
Serial number generate
Sorry forgot the link
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
"Tony" wrote:
Hi
I am writing a formula to generate a serial number automatically. I use
A1+1 in cell B1. A1=0, then each record will increase. But I cant do any
sorting. On the other hand, I dont want to change the formula into a value
then I can do sorting. Can anyone help please please?? (Dont be too
technical, I am not very good with computer, thanks)
Tony
|