Forum Discussion

lcovey's avatar
lcovey
Copper Contributor
Jun 08, 2023
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 ...
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jun 08, 2023

    lcovey 

    On reflection... In attached file see query Variant where all steps are done with Power Query User Interface

Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 08, 2023

lcovey 

You can easily do this with Power Query, example - sample attached:

lcovey's avatar
lcovey
Copper Contributor
Jun 08, 2023
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?

Resources