I have a spreadsheet with row one consisting of months. From Row2 downward, the first column of each row gives a product name and each of the other columns/cells in that respective row shows sales in that respective month.
I am trying to find the max # in each row (per product) and retrieve the month at the top to see which month had the most sales. I will put this into a mini separate chart so I can see which month per product had the most sales.
I know how to find the max per row, but I don't know how to retrieve the topmost cell in the column of the max#. Even more confused on how to do this for multiple rows.
Help is very appreciated. Thank you.