Select an empty cell where you want the median to appear
Type `=MEDIAN(range)`
Replace `range` with the cells containing your numbers, such as `A1:A10`
Press Enter
To find the median of non-adjacent cells, include multiple ranges, such as `=MEDIAN(A1:A5, C1:C5)`
To ignore blank cells, use the same `MEDIAN` function since blanks are ignored automatically
To find the median of filtered data, use a helper column if needed because `MEDIAN` includes hidden rows
To calculate the median for a table column, use structured references such as `=MEDIAN(Table1[ColumnName])`