Hi,
I can’t find in google answer to my problem. Hope you guys will help me!
This is my sheet:
This is shooting result. You can see here columns with points from 1 to 10 and number of shoots to each region of target.
And now I have to get median to get mean value of one shoot. In this example it should be something like this:
=MEDIAN(10;10;10;9;9;9;9;9;8;8)
Because we’ve 3x10, 5x9 and 2x8 shoots. How can I do that automatically?
Hope you guys understand my problem!