compare and find similar numbers in two columns

N

New User

How can I compare two dissimilar sets of numbers in two columns (random order
) and check if any of those numbers in the two columns are similar?
 
B

Bernie Deitrick

If you want SAME (not similar) then

=NOT(ISERROR(MATCH(number,othercolumn,FALSE)))

will return Truewhen the nubmer appears in the second (other) column.

For similar numbers (ones that round the same) then array enter (enter using Ctrl-Shift-Enter):

=NOT(ISERROR(MATCH(ROUND(number,2),ROUND(othercolumn,2),FALSE)))

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top