Hi,

If I have data that looks like the following:

(Row)
(1) Dan Ted Tom Bill

(2) 1 2 4 2


I am trying to create a formula that tests for ties. If there is a tie
in a row (in this case, Ted and Bill, keeping in mind there could be
more than two who tie) ideally I would like row 3 to output each
person's name who tie and the tie value.

Maybe some output like this:

(3) 2 Ted Bill


--
DunderMifflin
------------------------------------------------------------------------
DunderMifflin's Profile: http://www.excelforum.com/member.php...o&userid=23780
View this thread: http://www.excelforum.com/showthread...hreadid=374161