Smack on Peo, thanks a ton. Once I see it, it makes some sense to me.

Again, thanks

Regards,
Howard

"L. Howard Kittle" wrote in message
...
Hello Excel Users and Experts,

With the following, if the LARGE value occurs twice in the range, then two
of the formulas will return B11. If it occurs three times then of course
three of the formulas return B11.

Can the formulas be modified to divide LARGE equally between the cells
that return B11? So, if LARGE occured three times, and B11 = 70, then
each return would be 23.33. If it was a seven way tie, then each would
return 10.

Notice that the formulas run from B15 to B23, skipping 19 and 20, probably
not significant.

=IF(B15=(LARGE($B$15:$B$23,1)),$B$11,"")
=IF(B16=(LARGE($B$15:$B$23,1)),$B$11,"")
=IF(B17=(LARGE($B$15:$B$23,1)),$B$11,"")
=IF(B18=(LARGE($B$15:$B$23,1)),$B$11,"")
=IF(B21=(LARGE($B$15:$B$23,1)),$B$11,"")
=IF(B22=(LARGE($B$15:$B$23,1)),$B$11,"")
=IF(B23=(LARGE($B$15:$B$23,1)),$B$11,"")

Thanks
Regards,
Howard