Example A2=2 C2=4 E1=7 G1=3
I need the average of the lowest 3 values that are less than or equal to 4, the max is randomly distributed and not always in E1 down the columns. I have a header row with "LL" in the same columns to be averaged. In the example above I would need the avg of A2,C2,G1 not E1.
Bookmarks