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

=ROW(A1)

or am I missing it?

--
__________________________________
HTH

Bob

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

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

You forgot to add

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

--
__________________________________
HTH

Bob

"Dave Peterson" wrote in message
...
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

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

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

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

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.

DaveKid wrote:

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

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

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