How can I return the column name range from a row where I have found the highest vaule?
Example
I have rows of products and columns of years. The data is sales. I have returned the highest sales value and want to return the corresponding year in which those sales occurred.
Example
I have rows of products and columns of years. The data is sales. I have returned the highest sales value and want to return the corresponding year in which those sales occurred.