| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Consolidate mutiple names in Column
Hi, I have a column that has mutliple names in it like shown in the example
below. M Arque J Amati J Amati M Arque T Edwards J Hall J Hall M Desai M Desai Is it possible to consolidate the name in another column to count the names as one entry? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Consolidate mutiple names in Column
http://www.contextures.com/xladvfilter01.html#FilterUR
-- Regards, Peo Sjoblom "Greg" wrote in message ... Hi, I have a column that has mutliple names in it like shown in the example below. M Arque J Amati J Amati M Arque T Edwards J Hall J Hall M Desai M Desai Is it possible to consolidate the name in another column to count the names as one entry? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Consolidate mutiple names in Column
Thanks, that did help, but one remaining question. Now that I have
consolidated the duplicate names, can I assume the other remaining non duplicated names moved to the new column also? I have over 4K names, so I wanted to make sure the non-duplicate names were added also. "Greg" wrote: Hi, I have a column that has mutliple names in it like shown in the example below. M Arque J Amati J Amati M Arque T Edwards J Hall J Hall M Desai M Desai Is it possible to consolidate the name in another column to count the names as one entry? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Consolidate mutiple names in Column
Yes, if you apply the filter correctly it will "extract" one copy of each
name and just remove all the duplicates -- Regards, Peo Sjoblom "Greg" wrote in message ... Thanks, that did help, but one remaining question. Now that I have consolidated the duplicate names, can I assume the other remaining non duplicated names moved to the new column also? I have over 4K names, so I wanted to make sure the non-duplicate names were added also. "Greg" wrote: Hi, I have a column that has mutliple names in it like shown in the example below. M Arque J Amati J Amati M Arque T Edwards J Hall J Hall M Desai M Desai Is it possible to consolidate the name in another column to count the names as one entry? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Consolidate mutiple names in Column
Thank you again,
Greg "Peo Sjoblom" wrote: Yes, if you apply the filter correctly it will "extract" one copy of each name and just remove all the duplicates -- Regards, Peo Sjoblom "Greg" wrote in message ... Thanks, that did help, but one remaining question. Now that I have consolidated the duplicate names, can I assume the other remaining non duplicated names moved to the new column also? I have over 4K names, so I wanted to make sure the non-duplicate names were added also. "Greg" wrote: Hi, I have a column that has mutliple names in it like shown in the example below. M Arque J Amati J Amati M Arque T Edwards J Hall J Hall M Desai M Desai Is it possible to consolidate the name in another column to count the names as one entry? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plotting 3 column data as mutiple xy scatter plot lines on same graph | Excel Discussion (Misc queries) | |||
| Consolidate information from Column B Based on Info In Column A | Excel Worksheet Functions | |||
| Mutiple names in ActiveWorkbook.SendMail Recipients:= | Excel Discussion (Misc queries) | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Combining mutiple columns into one column | Excel Worksheet Functions | |||
Linear Mode
