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
To get the group name for the minimum value, please will need the MIN function, the MATCH function, and the INDEX function.
=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".