| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to add different characters to identical data in a column ?
I import the following data:
144S7950 146F2025 146F2431 146F2431 146F7008 146F7116 146F7127 146F7A01 146F7A01 146F7BHS 146F7BHS 146F7BHS I need to differentiate between the identical entries, because each of the above has different data in the next column. Is there a way to have Excel, when it finds duplicate entries, to add a chararacter in the front of the 2nd, 3rd, 4th, etc. data. Such as: 144S7950 146F2025 146F2431 A ~146F2431 B 146F7008 146F7116 146F7127 146F7A01 ~146F7A01 146F7BHS ~146F7BHS ^146F7BHS All the original data is 8 characters long. I'm using "lookup" to the above columns for a specific result, but the result is the first one it comes across, not necessarily the correct one. E.g., the 146F2431 has two entries, but the result needs to be B, and it's returning the first 146F2431 it finds, resulting in the incorrect A. I'm thinking that if I could differentiate between the duplicates, my lookup will provide the correct result. Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
