| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding unique names--then converting those names to unique number
Using either Excel 2003 or 2007, doesn't matter to me.
I have a set of data over many sheets, that I'm currently consolidating into one sheet. One of the columns is FamilyName, i.e. "Smith, Jones, Wilson, etc.". Some of the names in this column are repeated. What I need to do is take that column, find the unique names, and convert them into unique number values into another column. For example: FamilyName FamilyNum Jones 1111 Smith 2222 Wilson 3333 Rogers 4444 Smith 2222 Johnson 5555 Is something like this even possible? thanks for any advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the MAX number while considering similar names | Excel Discussion (Misc queries) | |||
| Finding unique numbers in a column | Excel Discussion (Misc queries) | |||
| Finding unique records from a list. | Excel Discussion (Misc queries) | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
Threaded Mode
