Forum Discussion
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 Shee...
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.
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
Hi Mollie1247
If both worksheets are formatted that way you can use power query to remove duplicates in a snap.
- I've never used power query before...
There's actually more than one sheet - but all will be compared to sheet 1.
All sheets vary from 50 rows - a couple of thousand....