Forum Discussion

C_T_M_81's avatar
C_T_M_81
Copper Contributor
Aug 09, 2022
Solved

How can I filter out rows that have duplicate values in adjacent columns?

I am trying to filter out rows with duplicate values that appear in adjacent columns.       Full disclosure, its been years since I used Excel in any meaningful way.  Any help is much appre...
excel
Formulas and Functions
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Aug 09, 2022

    C_T_M_81 

     

    You may create a helper column (say in column E) with the following formula...

    =C2=D2

    This formula will return TRUE when values in columns C and D are the same and FALSE if they are different and then you may apply the Filter and choose TRUE or FALSE as per your requirement.

     

    Please refer to the attached with formula in place.

     

     

     

     

     

     

mathetes's avatar
mathetes
Silver Contributor
Aug 09, 2022

C_T_M_81 

 

For your example, this function does it: =FILTER(A2:D15,C2:C15<>D2:D15)

I've attached a sample spreadsheet. The formula appears in cell G2; the results fill all the adjacent rows and columns.

 

(You missed the fourth row in your example, by the way.)

 

 

  • C_T_M_81's avatar
    C_T_M_81
    Copper Contributor
    Aug 09, 2022

    I am having trouble implementing this. I already have a formula active and am not sure which cell to insert the filter in. The sheet i am working on is a large one.  Over 14k rows.

Resources