Forum Discussion
Mollie1247
May 12, 2021Copper Contributor
Complex (Possibly) Formula Assistance Required - Find Duplicates
Hi all!
New to the community and really hoping someone can help!
I currently have 2 sheets in Excel (I think 365) that I am hoping to find duplicates on, let's just call them Sheet 1 and Sheet 2 for simplicity sake.
I need to find out whether the File ID (Column 2/Sheet 1) and the Part (Column 3/Sheet 1) are duplicate values of the File ID (Column 3/Sheet 2) and (Column 4/Sheet 2).
So the following example would be a duplicate:
Column 2 / Sheet 1 was 123456 AND Column 3 / Sheet 1 was 4
AND
Column 3 / Sheet 2 was 123456 AND Column 3 / Sheet 1 was 4
HOWEVER this example would NOT:
Column 2 / Sheet 1 was 123456 AND Column 3 / Sheet 1 was 4
AND
Column 3 / Sheet 2 was 123456 AND Column 3 / Sheet 1 was 2
Can anyone help? I have a thousand rows to check and can't afford to do each one individually!
Thanks 🙂
14 Replies
Sort By
- Yea_SoBronze Contributor
If
So the following example would be a duplicate:
Column 2 / Sheet 1 was 123456 AND Column 3 / Sheet 1 was 4
AND
Column 3 / Sheet 2 was 123456 AND Column 3 / Sheet 1 was 4
then what is on column 2 sheet 1? <==== my question might seem irrelevant but believe me it is.
- Mollie1247Copper Contributor
Sheet 1:
File Name ID Part A14141 1 A32691 2 Sheet 2:
File Name ID Part A14141 6 A32691 2 Hopefully this helps!
So Row one would NOT be a duplicate because it is a different part - but row 2 would because both column 2 AND 3 match- Yea_SoBronze Contributor
Hi Mollie1247
If both worksheets are formatted that way you can use power query to remove duplicates in a snap.