software

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

quot;NBMquot; wrote:
gt; I have two long columns of digits and
gt; need to identify same-row nonequal
gt; 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 gt; Filter gt; 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
savefile.com/projects/236895
xdemechanik
---
Hi!

In a third column enter this formula and copy down:

=IF(A1lt;gt;B1,TRUE,quot;quot;)

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

Biff

quot;NBMquot; gt; wrote in message
...
gt;I have two long columns of digits and need to identify same-row nonequal
gt; pairs. How can this be done?