Divide LARGE if multiple returns

  • Thread starter L. Howard Kittle
  • Start date

L

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
 
Ad

Advertisements

L

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
 
Ad

Advertisements

L

L. Howard Kittle

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

Again, thanks

Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top