So after you see a little something like =MEDIAN(A2:A51), make sure you style it precisely as it is—including the equals sign. =MAX(B2:C11) – Likewise, it finds the most range between column B from B2 and column C from C2 to row 11 in the two columns B and C. 36 https://excelnays.com/