Thread: How to identify same row matches in two columns of #s using Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default How to identify same row matches in two columns of #s using Excel
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

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


Reply With QuoteReply With Quote