Hi guys,
I have a big pivot table and what I need is the following:
For each value in column A I need to retrieve the value in row 4 that has the MAX value for that row. E.g. for row 5 the formula would scan the entire row, find the MAX value and derive the respective column and give me for that column the value in row 4 (= the output I need). I just can't wrap my head around how to do this. Could one of you guys help?
I only got a screenshot as my sample file is too big to upload here (1.8MB).
Regards,
Bookmarks