Forum Discussion
Solved
How do I pick the category of the smallest value in each row?
Hello, I'm working with a panel data like this. I want to pick the category name (in row 2) of the smallest value in each row. I know how to pick the smallest value of each row, but don't know how ca...
=INDEX($AP$1:$AW$1,MATCH(MIN(AP2:AW2),AP2:AW2,0))You can try this formula with the data of the example.
=INDEX($AP$1:$AW$1,MATCH(MIN(AP2:AW2),AP2:AW2,0))You can try this formula with the data of the example.