View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default 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