How do I obtain the median of unique values?

How do I obtain the median of unique values?

W column --> B2:B101 Unique Value
X column --> C2:B101 Unique Value
Y column --> D2:B101 Unique Value
Z column --> E2:B101 Unique Value
AA column --> F2:B101 Unique Value
AB column --> G2:B101 Unique Value
AC column --> H2:B101 Unique Value
AD column --> I2:B101 Unique Value

N2 --> N39
O2 --> N39
P2 --> N39
Q2 --> N39
R2 --> N39
S2 --> N39
T2 --> N39
U2 --> N39

Is it possible without auxiliary heat?

Try below array formula (confirm with Ctrl+Shift+Enter) in L39 and copy across

Please Login or Register  to view this content.

Hi! nflsales

Must be lack of expression.post modified