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(othercolu mn,2),FALSE)))
HTH,
Bernie
MS Excel MVP
"New User" <New
wrote in message
...
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?