Divide LARGE if multiple returns

[L. Howard Kittle]

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

 

[Peo Sjoblom]

I probably misunderstood what you want

=B11/COUNTIF(B15:B23,LARGE(B15:B23,1))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[L. Howard Kittle]

Hi Peo,
Thanks for the response.

That formula divides the Large value but not what I am looking for. I'll
try again to be more clear, I hope.

Say if B15 and B23 both = Large, then instead of each returning B11's value
of 70, each would return 35.

Regards,
Howard

 

[Peo Sjoblom]

=IF(B15=(LARGE($B$15:$B$23,1)),$B$11/COUNTIF($B$15:$B$23,LARGE($B$15:$B$23,1)),"")


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[L. Howard Kittle]

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

Again, thanks

Regards,
Howard