In the winner section below. What formula would I use to award the
person with the hightes score, Roger, the March pot of $70.00

Store 244 MAR
Roger $10
Andrew $10
Mark $10
David $10

Store 245
Mickey $10
Danny $10
Donald $10
$70

TEST SCORES
Store 244 MAR
Roger 95
Andrew 87
Mark 80
David 93


Mickey 90
Danny 86
Donald 88

WINNER
Store 244
Roger (I'd like a formula in each cell by each name that returns the
total value of the monthly pot if that person has the highest score.
But if 2 or more employee(s) ties they split the pot.
Andrew
Mark
David

Store 245
Mickey
Danny
Donald


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=524966