I have created a task list that will be shared by several people.
Every time a new task is added I want a unique incremental number to be
assigned to it automatically in the first cell i.e. upon exiting the first
cell in a new row.
I use DMax to do this in Access - is there something similar in Excel?
Many thanks
CW

Column A should be set aside for "Sequence No":
I like to use the formula (say in cell A10)
=Row() and copy down to A100

It replicats the row number as a seq No;
IF you delete a row - it automatically
renumbers things - SO THIS MIGHT NOT BE A
GOOD IDEA, but then again It might be
something you could use..





"CW" wrote:

I have created a task list that will be shared by several people.
Every time a new task is added I want a unique incremental number to be
assigned to it automatically in the first cell i.e. upon exiting the first
cell in a new row.
I use DMax to do this in Access - is there something similar in Excel?
Many thanks
CW

Many thanks for the suggestion - it was better than anybody else came up
with!!!
Unfortunately as you pointed out, it doesn't "store" the number permanently,
and as we will constantly shuffle tasks up and down when re-prioritising,
they are going to lose their numbers if I use this.
But it was a good thought and something I may well use in other
circumstances, so thanks again!
CW


"JMay" wrote:

Column A should be set aside for "Sequence No":
I like to use the formula (say in cell A10)
=Row() and copy down to A100

It replicats the row number as a seq No;
IF you delete a row - it automatically
renumbers things - SO THIS MIGHT NOT BE A
GOOD IDEA, but then again It might be
something you could use..





"CW" wrote:

I have created a task list that will be shared by several people.
Every time a new task is added I want a unique incremental number to be
assigned to it automatically in the first cell i.e. upon exiting the first
cell in a new row.
I use DMax to do this in Access - is there something similar in Excel?
Many thanks
CW