Hello all,
I need your help because I am a bit of a newbie! I have a spreadsheet that has a unique number for each row that gets sorted by due date. When a new record is added, the number for the row has to be the next in sequence. Is there a way to automatically generate the next number that should be used for a new row that is not a duplicate of any of the numbers above it.
Here's an example of what I mean:
1 John Doe email@email.com 1/1/2010
2 Jane Smith email@email.com 5/1/2010
<generate next number = 3> etc...
If it can't be automatically generated, then even if I can pick it from a list would be okay.
The reason I can't just number the rows beneath it and wait for them to be filled in is that this list gets exported based on the number of records in it. If I fill in numbers it exports blank records.
I'm hoping someone here could help me!
I need your help because I am a bit of a newbie! I have a spreadsheet that has a unique number for each row that gets sorted by due date. When a new record is added, the number for the row has to be the next in sequence. Is there a way to automatically generate the next number that should be used for a new row that is not a duplicate of any of the numbers above it.
Here's an example of what I mean:
1 John Doe email@email.com 1/1/2010
2 Jane Smith email@email.com 5/1/2010
<generate next number = 3> etc...
If it can't be automatically generated, then even if I can pick it from a list would be okay.
The reason I can't just number the rows beneath it and wait for them to be filled in is that this list gets exported based on the number of records in it. If I fill in numbers it exports blank records.
I'm hoping someone here could help me!