send unique, duplicates and 3x duplicates to a seperate sheet

**cp49321** · 06-21-2012, 10:47 AM

Good morning,
I am trying to combine several different data sheets and have the output show items
in one list, in two lists, and all 3 lists.
I can't quite figure out what I am missing.
Workbook is attached, and any suggestions are appreciated.
Thanks,
DH

**stanleydgromjr** · 06-21-2012, 11:15 AM

cp49321,

Can you attach another workbook that contains:
1. the raw data in Sheet1 (same as the original workbook)
2. worksheet Unique, where you manually create/display the information you are looking for from Sheet1
3. worksheet Duplicates, where you manually create/display the information you are looking for from Sheet1
4. worksheet Duplicates3X, where you manually create/display the information you are looking for from Sheet1

**cp49321** · 06-21-2012, 12:18 PM

stanleydgromjr
I have attached my raw sheets, I have 3 sources of information.
I would like to have the next 3 tabs show the unique and duplicate entries.
I have used cond. format to find and manually copy out these items, but it
is becoming a daily project.
I appreciate the help, and any other idea that may work better.
TIA,
DH

**stanleydgromjr** · 06-21-2012, 10:37 PM

cp49321,

What is the logic (fields/columns/titles) to find:
unique?
duplicates?
3x duplicates?

**cp49321** · 06-22-2012, 08:47 AM

Sorry, I need to find items in Column A that match, and then copy out the unique, double and triple matches based on the location in Column G(my data lists come from the 3 sources in column G).
My goal is to have all match data sets match all 3 lists.
If I can show the matches another way on the same page I would be happy also.
I updated my .xls.
I appreciate the help.
Thanks again,
DH

**stanleydgromjr** · 06-22-2012, 04:03 PM

cp49321,

I need to find items in Column A that match, and then copy out the unique, double and triple matches based on the location in Column G(my data lists come from the 3 sources in column G).

I am sorry, but I can not follow your logic from the three sheets Syteline, Gagetrak, and inventory, to sheets Unique, match 2, and match3.

In the Quick Reply box, just put the word BUMP. Then, click on the Post Reply button, and someone else will assist you.