Hi,
I have a pivot table with format as follows:
A B C D
1 company name country1 country2 country3 ...
2 company1 10 2 3
3 company2 1 35 5
4 company3 0 4 10
I find the highest export quantity in all countries by the formula max(B2:D4) which comes out as 35.
Now I want to find the company name corresponding to this max value.
Need urgent help with this please. I've spent several hours on just this question of my project.
Regards