Aggegate formula not giving sum of lowest 5 cells when there are more than 5 cells that are equal. How do I make G2 equal the lowest 5 cells from column D when all from that team have the same score? G2 should equal 4.5
help_file.xlsx
Aggegate formula not giving sum of lowest 5 cells when there are more than 5 cells that are equal. How do I make G2 equal the lowest 5 cells from column D when all from that team have the same score? G2 should equal 4.5
help_file.xlsx
Last edited by mbsmeltzer; 08-31-2015 at 03:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks