Serial number generate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Tony,

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

Mike
 
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
 
Back
Top