Forum Discussion
Solved
Identifying duplicates
Hello, I have a table with coordinates and company name. I need to find coordinates that are the same but have a different company name. Any thoughts?
I would use Power Query and Group By 2 columns (Platuma and Ilguma) and count the values.
If you can paste as values some data we might "play-along" a bit.
If you liked my solution please give it a thumbs up 👍.
If I did answer your question please mark my post as a solution ✅.
Thank you !
Cristian
Cristian_Angyal
Most Valuable Professional
Most Valuable ProfessionalI would use Power Query and Group By 2 columns (Platuma and Ilguma) and count the values.
If you can paste as values some data we might "play-along" a bit.
If you liked my solution please give it a thumbs up 👍.
If I did answer your question please mark my post as a solution ✅.
Thank you !
Cristian