0
It would be a complex formula and it would be not foolproof as more than one cell may have the highest value in a range. If it is a case that only one cell can have the highest value, then it can work. If not, then look at using conditional formatting to highlight values in the text column. If there can only be one cell with the highest value, then below explains how it will do it.
To explain the process. First you have to find the highest value with the MAX function Then you have to find where it is in the list, which you can do using the MATCH function. That will give you a number of the position in the list. You can use that number to determine the row the highest value is in. If the list does not start in row 1, which is highly likely, then you will need to add a value to make up for that. You will know what the column of the text values is, and together you will have the address of a cell in that column, taking that column and the row the highest value is in. You use the ADDRESS function to do that. They you need to find the content of the cell, using the INDIRECT function.
Say your numbers were in cells B10 to B180 and the text values were in A10 to A180. As the first cell is in row 10, then you will need to add 9 to the Match value to make up the difference. The 1 represents the first column, in the ADDRESS function. Your full function would be like this:
=INDIRECT(ADDRESS(9+MATCH(MAX(B10:B180),B10:B180),1))
If there is more than one cell with the highest, then the last high in the list will show its corresponding text.
What else can I help you with?
What is non-adjacent cell in Microsoft Excel 2007?
Non-adjacent cells are cells that do not touch each other. Cell A3 and Cell D9 are non-adjacent. A3 and B3 or A3 and A4 would both be sets of adjacent cells.
A 1 in Microsoft Excel is?
A 1 in Microsoft Excel is a value. A1 is a cell in column A and row 1.
How do you time stamp a cell in Microsoft Excel?
You do not. Excel does not record the change date of an individual cell.
What is the home cell of Microsoft Excel?
A1
What is the column and row location of a cell in Microsoft Excel 2007?
Cell Reference
What affects the data in the cell on Microsoft Excel?
Formatting can change the look of a cell and its contents.
What is the definition of A4 cell?
It is the cell in column A, row 4 in a spreadsheet, such as Microsoft Excel.
What is the use of name menu in Microsoft Excel?
I am not aware of a name menu in Excel. However, Excel has a name box that displays the name or cell reference of the active cell.
When you change the color of the fill in a cell in excel you are changing its?
When you change the color of the fill in a cell you are changing its format. This action applies to Microsoft Excel.
What is cell in Microsoft office excel?
A cell is a rectangle that can hold a number, text, formula etc.
What does ALT ENTER do in Microsoft Excel?
It gives you a line-break inside of a cell.
In Microsoft Excel cell How do you change the negative sign to positive?
Multiply by -1
