| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy down doesn't change row reference | Excel Discussion (Misc queries) | |||
| Copy without reference cells | Excel Discussion (Misc queries) | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
| Copy a number from one cell to another depending on first number | Excel Worksheet Functions | |||
| Column Reference Copy | Excel Worksheet Functions | |||
Hybrid Mode
