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 Shee...
Mollie1247
Copper 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_So
May 18, 2021Bronze Contributor
Hi Mollie1247
If both worksheets are formatted that way you can use power query to remove duplicates in a snap.
- Mollie1247May 18, 2021Copper ContributorI'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....- Yea_SoMay 18, 2021Bronze Contributor
- Mollie1247May 18, 2021Copper Contributor5 sheets - currently they aren't all identical but they can be with little effort if that makes it easier 🙂