Match and Count duplicate names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hey Bernd - Thanks - i'll have to study this one... it's a little more
complex.
Thanks again
 
Back
Top