"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
---