Linking a cell to the column in which it is found.
Posted by Mike Beerman on November 20, 2001 2:30 PM
I have an array of data with each column titled. I would like to search the data using the LARGE function and assign that number to a cell. I would also like to identify the column that the number was found in. For example if the data array contained the number 300 in the column "Vega" I would like to paste the 300 in one cell using the LARGE function and then automatically paste the column title "Vega" in the cell adjacent. I would like to do this in such a way as to update both fields automatically if another larger number is entered in a different column.