| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a Custom Column based on an existing Column (EXPERT)
I need to add a new column based on an existing column of data.
The existing data is in the format below: ID67 ID6802 ID6802 ID61 IA91 IA92 BMID75 BMID25 Each one of the data points will be grouped into different categories like below, ID67 = Red ID6802 = Orange ID6802 = Orange ID61 = Pink IA91 = Brown IA92 = Brown BMID75 = Black BMID25 = Black I would manually do it but there are a couple thousand rows. Also there are about 400 different types of data ("IA91") that have an associated group ("Brown"). Can someone give me a formula for this that can be applied to multiple spreadshirts once the association is established? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a new column based on data in an existing column | Excel Discussion (Misc queries) | |||
| Adding a Baseline Value into my existing column graph. | Excel Worksheet Functions | |||
| Adding one column based on results from another column | Excel Discussion (Misc queries) | |||
| adding extra text into an existing column | Excel Worksheet Functions | |||
| Adding Values Based on a Separate Column | Excel Discussion (Misc queries) | |||
Threaded Mode
