How to identify same row matches in two columns of #s using Excel

N

NBM

I have two long columns of digits and need to identify same-row nonequal
pairs. How can this be done?
 
M

Max

NBM said:
I have two long columns of digits and
need to identify same-row nonequal
pairs. How can this be done?
Click to expand...

One way ..

Assume data in cols A and B, from row2 down
Put in C2, copy down: =A2=B2

Where col C evaluates to: FALSE
would be the rows you're interested in

Just do a Data > Filter > Autofilter on C1,
select FALSE from the droplist
to filter out all rows with FALSE
for closer inspection

And if there's possibility that
some numbers in cols A/B might be text numbers

Put instead in C2, copy down:
=A2+0=B2+0
 
B

Biff

Hi!

In a third column enter this formula and copy down:

=IF(A1<>B1,TRUE,"")

If the pair doesn't match the formula will return TRUE.

Biff
 
Top