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 ...
  • 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

Resources