View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gayla
 
Posts: n/a
Default Find duplicate entries within mulitple worksheets, then listing th

I have each months data seperated into multiple worksheets. Now I need to
identify any entry that is duplicated and how often it is duplicated. I need
the result to be ASA-2-145006 (2), ASA-2-305001 (2), ASA-2-305002 (2). My
example data is below. Any help would be appreciated.

Example:
Jan Worksheet Feb Worksheet

Column A Column A
ASA-2-145006 ASA-2-145006
ASA-2-205003 ASA-2-205004
ASA-2-205004 ASA-2-305001
ASA-2-205005 ASA-2-305002
ASA-2-205006 ASA-2-305003
ASA-2-305001 ASA-7-245001
ASA-2-305002 ASA-7-245002