J
Josh7777777
I'm having trouble finding a way to perform a function in excel.
hopefully someone here can help me out.
I have a spreadsheet with several hundred rows of data in it. Column
of each row is a text name, and Column B is a numerical value.
At the end of the worksheet, I'd like to display the name and numerica
value of the row with the lowest number in column B.
I can't simply sort the entire worksheet though, because I'd like it t
stay in alphabetical order.
Returning the lowest numerical value is easy. I can just take th
minimum of column B. What I'm having trouble with, is finding a way t
return the text value in column A based on that number in B.
Any ideas?
THanks in advance
Jos
hopefully someone here can help me out.
I have a spreadsheet with several hundred rows of data in it. Column
of each row is a text name, and Column B is a numerical value.
At the end of the worksheet, I'd like to display the name and numerica
value of the row with the lowest number in column B.
I can't simply sort the entire worksheet though, because I'd like it t
stay in alphabetical order.
Returning the lowest numerical value is easy. I can just take th
minimum of column B. What I'm having trouble with, is finding a way t
return the text value in column A based on that number in B.
Any ideas?
THanks in advance
Jos