Find uniques & duplicates values in different Sheets.

[Fotis1991]

Hi.

My point is as follows:
In two different Sheets, I have a column(in eatch one) that contains some numbers. Some of them are unique and some are same.
My subject is on a different sheet, to have a column with unique numbers and a column with those who are in both of the columns ..
Ι''ll appreciate any help.

[abousetta]

Hi,

There are two approaches I can think of and they depend on how often you will be using this.

1) Manual: Copy all data into one two columns on a new sheet (e.g. same data in column A and C on sheet4). Then remove all duplicates from one column and use countif to determine the number of times each unique number comes up in Column A.

2) VBA: This will require more information on the structure of your workbook and where you want the final list to populated.

Hope this helps.

abousetta

[Fotis1991]

Hi.

Thank you for your answer.

To be honest (because I do not know VBA), I hope someone can give me a solution, using formoulas.

[abousetta]

Hi,

Have a look at Sheet4 in the attachment. Here's what I did:

1) Copy data from Sheet2 - Column A and Sheet 3 - Column A to Sheet 4 - Column A.

2) Highlighted Column A

3) Click on Data --> Filter --> Advanced --> Copy to C1 (make sure that you check 'Unique records only'). This will generate the list without any duplicates.

4) In D2, add the formula:

Please Login or Register  to view this content.

and drag down

Now you have a list of unique numbers denoted with 1 and duplicates in both sheets denoted with 2. You can filter or sort, etc. depending on your needs.

Hope this helps.

abousetta

[Fotis1991]

Ηι

Thank you very much for your offer, but even more for your interest.
Certainly it is a very good approach.
If another friend do not give us a better solution would probably use it.
Working course these hours, I found a formula that can find the same prices(using just one column), but nothing for the duplicate.
The formula for the same (Sheet1) is.

Please Login or Register  to view this content.