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. Anonymous
    2023-02-22T16:50:52+00:00

    Understood, would I be able make the columns into a dynamic scrollable data set? I have tried messing with the OFFSET formula, but I can't get it to produce a logical value.

    =OFFSET($B$1, 0, 0, COUNTA($B:$B),1)

    0 comments
  2. Anonymous
    2023-02-22T18:16:34+00:00

    Hi Snow,

    The formula is sticking?

    0 comments
  3. Anonymous
    2023-02-22T19:07:36+00:00

    Actually I figured it out. Thank you so much, you have been a huge help. I will mark this as solution, you have helped a lot of my questions, is there a survey or something I can fill out for you?

    0 comments