Serial number generate

[Tony]

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 can’t do any
sorting. On the other hand, I don’t want to change the formula into a value
then I can do sorting. Can anyone help please please?? (Don’t be too
technical, I am not very good with computer, thanks)


Tony

 

[David Biddulph]

What do you mean by "But I can't do any sorting"?

 

[Mike H]

Tony,

It sounds like you are generating sequential numbers. Have a look here for
some alternative methods.

Mike

 

[Mike H]

Sorry forgot the link


http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

 

[Tony]

David

I am when I do the sorting, the rest of data can be sorted, but the serial
no. keep the same (doesn't follow the record)

Tks
Tony