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

Bob Phillips wrote:

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

"DaveKid" wrote in message
...
Hi

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

"Dave Peterson" wrote:

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 wrote:

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" wrote:

Use the row number???

DaveKid wrote:

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

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson