Here’s a compact solution to find the single most frequent value: =INDEX(A2:A6,MODE(MATCH(A2:A6,A2:A6,0))) If entered into cell A1, this will display the value that appears most frequently in the range A2:A6 (see column A below). Note: In a situation where more … Continue reading →