When working with Excel, especially when you automate a report, you may need to get the group name for the minimum value.
Example: You are working with the survey data with many different communities, and in each community's data, column A is the participants' age groups, and column B is the number of responses in the age group.
Formula: To get the age group that has the least responses
=INDEX(A2:A6, MATCH(MIN(B2:B6), B2:B6,0))
- MIN(B2:B6) is to find the minimum value in the data range B2:B6, which returns 4;
- MATCH(MIN(B2:B6), B2:B6,0) is to find the relative row number that has the minimum value and it returns 1;
- INDEX(A2:A6, MATCH(MIN(B2:B6), B2:B6,0)) is to get the group name from column A, which is "Under 18 yrs".