View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default How to identify same row matches in two columns of #s using Excel

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


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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---