Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and Count duplicate names
Hello all: I have a list of names I need to match with another workbook. I
also want to count how many times these names appear, including duplicates. For example, the list in the report would be: Joe Smith Avery Terry Patty Wong Kyle Robbs Mary Kay Patty Wong Mary Kay Jim Beam Avery Terry My list I need to match and count how many times they appear would consist of: Mary Kay Kyle Robbs Avery Terry TIA for your help Donald |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and Count duplicate names
A13: holds Mary Kay
A14: holds Kyle Robbs and so on... =COUNTIF(rng,A13) copy down "Donald B" wrote: Hello all: I have a list of names I need to match with another workbook. I also want to count how many times these names appear, including duplicates. For example, the list in the report would be: Joe Smith Avery Terry Patty Wong Kyle Robbs Mary Kay Patty Wong Mary Kay Jim Beam Avery Terry My list I need to match and count how many times they appear would consist of: Mary Kay Kyle Robbs Avery Terry TIA for your help Donald |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and Count duplicate names
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and Count duplicate names
That worked perfect! - Thank you
"Teethless mama" wrote: A13: holds Mary Kay A14: holds Kyle Robbs and so on... =COUNTIF(rng,A13) copy down "Donald B" wrote: Hello all: I have a list of names I need to match with another workbook. I also want to count how many times these names appear, including duplicates. For example, the list in the report would be: Joe Smith Avery Terry Patty Wong Kyle Robbs Mary Kay Patty Wong Mary Kay Jim Beam Avery Terry My list I need to match and count how many times they appear would consist of: Mary Kay Kyle Robbs Avery Terry TIA for your help Donald |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and Count duplicate names
Hey Bernd - Thanks - i'll have to study this one... it's a little more complex. Thanks again "Bernd" wrote: Hello, I suggest to use mz UDF lfreq: http://www.sulprobil.com/html/listfreq.html Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate names | Excel Discussion (Misc queries) | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
deleting duplicate names | Excel Discussion (Misc queries) | |||
deleting duplicate names | Excel Worksheet Functions |