L

#### L. Howard Kittle

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