26 May 2025 ... Use =MEDIAN(range) to find the median. · Works with numbers in a single or multiple cells. · Helpful in reports where average might be misleading.