Share via

Dynamically comparing multiple columns in excel in the same sheet.

Anonymous
2023-02-20T15:12:09+00:00

Hello,

I have data imported from pdfs into columns that I am trying to compare if the data inside the columns is equal to each other.

Is there a way to check if the data from B2:B14 is equal to C2:C14 and that is equal to D2:D14 and so on...? The amount of rows will not change, but amount columns will. Can this check be done in the same sheet? Any help or feedback would be much appreciated.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-02-22T17:07:07+00:00

    1.Create a data validation list - Drop down list for The title.

    =$B$1:$D$1

    2.Use filter formula to the get the column you want.

    =FILTER(B1:D9,B1:D1=B15)

    1 person found this answer helpful.
    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2023-02-20T23:24:00+00:00

    Hi,

    In cell E2, enter this formula and drag down

    =and(B2=C2,C2=D2)

    Hope this helps.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-02-21T09:16:38+00:00

    Hi Richard,

    Select the range C2:E14, apply conditional formatting use formula: =C2<>$B2

    Best Regards,

    Snow Lu

    0 comments
  3. Anonymous
    2023-02-21T15:06:27+00:00

    Thank you so much Snow. This works.

    Is there a way to print only one of the columns after this check has been done. Getting rid of all the other columns and only printing one correct column?

    0 comments
  4. Anonymous
    2023-02-21T15:22:09+00:00

    It is based on the data and it will have a lot of conditions. It is suggested to manually remove the incorrect ones.

    0 comments