copy reference number
 

I have created a large spreadsheet

Some 30000 Items

I wsh to add a field for MYREference number at the end of each line

for example badtimes1 then I would like to be able to automatically copy
badtimes1 all the way down to badtimes3000o with a copy/Formula I am not ure
how how to do this


Any help would be most appreciated

copy reference number
 

Assume text runs in A1 down
place in B1:
=TRIM(A1)&TEXT(COUNTIF($A$1:A1,A1),"000")
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"eventhebadtimesaregood" wrote:
I have created a large spreadsheet

Some 30000 Items

I wsh to add a field for MYREference number at the end of each line

for example badtimes1 then I would like to be able to automatically copy
badtimes1 all the way down to badtimes3000o with a copy/Formula I am not ure
how how to do this


Any help would be most appreciated

copy reference number
 

=A1&ROW(A1)

"eventhebadtimesaregood" wrote:

I have created a large spreadsheet

Some 30000 Items

I wsh to add a field for MYREference number at the end of each line

for example badtimes1 then I would like to be able to automatically copy
badtimes1 all the way down to badtimes3000o with a copy/Formula I am not ure
how how to do this


Any help would be most appreciated