Unique Reference Number

[DaveKid]

Hi, I would like to create a unique reference number for each row of data.
How can I do this?

 

[Bob Phillips]

=ROW(A1)

or am I missing it?

 

[Dave Peterson]

Use the row number???

Hi, I would like to create a unique reference number for each row of data.
How can I do this?

 

[Bob Phillips]

You forgot to add

.... or am I missing it?<BG>

 

[DaveKid]

Hi

Sorry. i didnt explain properly. The unique reference needs to be unique to
the data in the row and not the position in the sheet as this will change on
a weekly basis.

Thanks

 

[Dave Peterson]

Start with the row number and always add new data at the bottom of the list.

Then use the maximum of the previous data plus 1.

If you insert the data anywhere in the list, you'd have to check for the maximum
of the entries above and below and use one more than that.

 

[DaveKid]

Hi

I do not know what you mean? How do I do this?

 

[Dave Peterson]

Make sure that the statusbar is showing.
In xl2003 menus:
Tools|Options|View tab|check status bar

Then rightclick on this status bar (embossed area to the far right) and choose
max.

Then select column A
Make a mental note of the number that appears in the status bar. Add one to it.

Insert your new row of data. Use that number as the id.

Hi

I do not know what you mean? How do I do this?

 

[Bob Phillips]

On row, add a id of 1.

After that, add a formula of

=MAX($B$1:OFFSET(B2,-1,0)

assuming row 2

--
__________________________________
HTH

Bob

Hi

I do not know what you mean? How do I do this?

 

[Dave Peterson]

And then convert to a value. The sort may mess things up.