| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating reference numbers from column of data
Hi,
Here is what I am struggling with: The table will hold a thousand rows In one column there is a ref. number between 1 and 50 that I will input I would like another column to generate a sub-reference in line with the reference numbers above. So, it would look like: Column A Column B 1 1.1 2 2.1 2 2.2 3 3.1 4 4.1 2 2.3 3 3.2 1 1.2 2 2.4 and so on. I am thinking that I need to use CONCATENATE but after that am stumped. Help gratefully recieved |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating reference numbers from column of data
e.g. what will be the next sub-ref after 2.9
-- regards, "LucasD" wrote: Hi, Here is what I am struggling with: The table will hold a thousand rows In one column there is a ref. number between 1 and 50 that I will input I would like another column to generate a sub-reference in line with the reference numbers above. So, it would look like: Column A Column B 1 1.1 2 2.1 2 2.2 3 3.1 4 4.1 2 2.3 3 3.2 1 1.2 2 2.4 and so on. I am thinking that I need to use CONCATENATE but after that am stumped. Help gratefully recieved |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating reference numbers from column of data
Hi Lucas ,
put this formula in cell a1 and copy down. =A1&"."&COUNTIF($A$1:A1,A1) Harshawardhan.shastri ================================================== ========= "LucasD" wrote: Hi, Here is what I am struggling with: The table will hold a thousand rows In one column there is a ref. number between 1 and 50 that I will input I would like another column to generate a sub-reference in line with the reference numbers above. So, it would look like: Column A Column B 1 1.1 2 2.1 2 2.2 3 3.1 4 4.1 2 2.3 3 3.2 1 1.2 2 2.4 and so on. I am thinking that I need to use CONCATENATE but after that am stumped. Help gratefully recieved |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating reference numbers from column of data
LucasD wrote:
Hi, Here is what I am struggling with: The table will hold a thousand rows In one column there is a ref. number between 1 and 50 that I will input I would like another column to generate a sub-reference in line with the reference numbers above. So, it would look like: Column A Column B 1 1.1 2 2.1 2 2.2 3 3.1 4 4.1 2 2.3 3 3.2 1 1.2 2 2.4 and so on. I am thinking that I need to use CONCATENATE but after that am stumped. Help gratefully recieved Assuming your data starts in row 1, put the following in B1 and copy down: =A1&"."&COUNTIF($A$1:A1,A1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting text to cell reference and column letters to numbers -please help | Excel Worksheet Functions | |||
| Creating a column with just data before comma in another column | Excel Worksheet Functions | |||
| Find cell reference in an column of numbers? | Excel Worksheet Functions | |||
| Creating a column of numbers from a column with some blanks? | Excel Discussion (Misc queries) | |||
| Converting column & row numbers to a cell reference | Excel Worksheet Functions | |||
Linear Mode
