Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add data to a column based on other column data
This is what I currently have:
Number Date_tested 5090002 1-Feb-01 5090002 1-May-01 5090002 15-Apr-03 5090034 1-Sep-00 5090034 15-May-01 5090034 15-Apr-03 I need to add the text "Test-1" "Test-2" etc based on the number in the first column, in other words, when the number in the first column changes I need the added text to start over at "Test-1" Number Date_tested Test Number 5090002 1-Feb-01 Test-1 5090002 1-May-01 Test-2 5090002 15-Apr-03 Test-3 5090034 1-Sep-00 Test-1 5090034 15-May-01 Test-2 5090034 15-Apr-03 Test-3 Any ideas? Thanks!!! Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add data to a column based on other column data
Fred wrote: This is what I currently have: Number Date_tested 5090002 1-Feb-01 5090002 1-May-01 5090002 15-Apr-03 5090034 1-Sep-00 5090034 15-May-01 5090034 15-Apr-03 I need to add the text "Test-1" "Test-2" etc based on the number in the first column, in other words, when the number in the first column changes I need the added text to start over at "Test-1" Number Date_tested Test Number 5090002 1-Feb-01 Test-1 5090002 1-May-01 Test-2 5090002 15-Apr-03 Test-3 5090034 1-Sep-00 Test-1 5090034 15-May-01 Test-2 5090034 15-Apr-03 Test-3 Any ideas? Thanks!!! Fred To claify... there will be different number of tests, so some will have Test-1 to Test-3 some will have Test-1 to Test-4.... or Test-1 - Test-6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding digits in a column based on data in a separate column | Excel Discussion (Misc queries) | |||
Adding column data based on match in 2nd column - Help | Excel Worksheet Functions | |||
Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
making a new column based on data in an existing column | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) |