New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Find row for max value of all columns in a pivot table

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Find row for max value of all columns in a pivot table

Postby rabiamalik » Tue Apr 26, 2016 5:49 pm

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
  • 0

rabiamalik
Rookie
 
Posts: 1
Joined: Apr 26, 2016
Reputation: 0
Excel Version: 2013

Re: Find row for max value of all columns in a pivot table

Postby vikas270880 » Sat May 28, 2016 3:49 am

can you please provide a worksheet with data? I am not getting you at all.
  • 0

vikas270880
Rookie
 
Posts: 5
Joined: May 28, 2016
Reputation: 0
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 40 guests