Need a Quick answer on this one.........
On possible "quick" solution might be the following. However, this returns
an #N/A error if all numbers are unique. Not sure how you want to handle
that. This looks at the three numbers in A1:C1
=SUM(A1:C1)-2*MODE(A1:C1)
HTH
Dana DeLouis
"Dan B" wrote in message
...
I have three columns of numbers....I need to find exact matches between 2
of
them. If a match is found I need to copy a number from the other column
to
an empty column. For example, if any number in column B matches any
number
in column C, then copy the number in A (next to the match it found in B)
to
column D.
I hope that makes sense.
Thanks,
Dan
|