How to automatically compare values across columns

  • Thread starter Thread starter Guillaume
  • Start date Start date
G

Guillaume

Hey, I'd like to know if it's possible to automatically
select for rows that have equal (or different, if the
majority of rows have equal) values in two adjacent
columns. That is, let's say you've got two columns and
they're hundreds of rows long, but each row's value is
simply either a 1 or a 2. How, without simply scrolling
down and looking yourself, can you determine which rows
both have 1 (or 2)? Or if most of the rows have the same
value in both columns, how do you select for those that
don't?
 
I would use a "helper" column: assuming headers in row 1 and data in columns A
and B, in C2 put the formula =IF(B2=A1,0,1). Copy this down. Then use
Data/AutoFilter on column C and select either the 0's or 1's, depending on
whether you want to see the matches or the mismatches.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing data between two columns 4
Find different values in columns (difficult) 1
how do you have 2 criterias be picked up in a lookup? 2
comparing two columns 2
comparing 2 columns 2
counting blank cells within two columns 2
Having Blank Cells, etc. ? 1
How to transfer values from one column to a big table? 3

Back
Top