14 May 2024 ... I use the formula =MEDIAN(A101:A113) to find the median for that cell range. CONCAT() to combine names. CONCAT() combines text from multiple ...