Hello-

I am trying to calculate median of many observations across columns based on attributes in the first column

A B C D E
Sam 17 23 40 93
Sam 45 63 29 85
Clark 52 34 74 60
Clark 85 97 40 50
Steve 80 62 75 32
Sam 47 89 31 78
Clark 94 70 38 82
Steve 95 20 75 57

For e.g., I want to write a formula which checks for "sam", and calculates median for all values in rows 2,3, and 7 (columns B-E).

Can anyone please help me with this?

Thx
Rahul