Forum Discussion
Solved
How to find matching values in 2 cells
I have an excel sheet with 10,000 rows. I need to find any duplicates that have the same values in both A & B. For example: A1 is #6805 & B1 is $4.95 (I need to find any other rows that have this ...
Thank you for responding. I've never done a Power Query - what is the formula to get the Row numbers to show where the dupes are?
On reflection... In attached file see query Variant where all steps are done with Power Query User Interface
what is the formula to get the Row numbers to show where the dupes are?
- Click somewhere in the Green table => A Query menu will appear in the Excel menu
- In the Query menu > Edit (this opens the Power Query Editor)
On the right side of the screen you should see the APPLIED STEPS where the 2nd one (AddedIndex) does what you ask
I set it to start at 2 - adjust according to where your data actually start