If you have a range of values in one column and the corresponding names of individuals in another column. You may want to find out the name of the person having the least value in the column of numbers.
For e.g. If you have data like this. And you would like to find out the name of the person having the least value in column B.
Then you can use this formula -
In C1 put the above formula. The result is as shown -
So the name Joe will appear since he has the least value in column B, compared to the rest.