Extracting top performing products by region
 

I have to analyse different products being sold in different regions, the
data are tabulated by products and by region. I have to extractthe best
selling product by region and overall.

The table is as follows:

desc Region1 Region2 Region3 Total
Prod A 2 5 6 13
Prod B 8 4 2 14
Prod C 6 2 7 15


Top Perf Prod B Prod A Prod C Prod C

Can anyone help me with a formula which would extract the top performing
product for each region and overall.

Looking forward to receiving your valuable help

Extracting top performing products by region
 

Hi

try this in a cell and drag right. I have assumed your table is in A1 - E4

=INDEX($A$2:$A$4,MATCH(MAX(E2:E4),E2:E4,FALSE),1)

Mike

"Wins07" wrote:

I have to analyse different products being sold in different regions, the
data are tabulated by products and by region. I have to extractthe best
selling product by region and overall.

The table is as follows:

desc Region1 Region2 Region3 Total
Prod A 2 5 6 13
Prod B 8 4 2 14
Prod C 6 2 7 15


Top Perf Prod B Prod A Prod C Prod C

Can anyone help me with a formula which would extract the top performing
product for each region and overall.

Looking forward to receiving your valuable help

Extracting top performing products by region
 

I pasted the formula after I had dragged it, strat with this one and drag right

=INDEX($A$2:$A$4,MATCH(MAX(B2:B4),B2:B4,FALSE),1)

Mike

"Mike H" wrote:

Hi

try this in a cell and drag right. I have assumed your table is in A1 - E4

=INDEX($A$2:$A$4,MATCH(MAX(E2:E4),E2:E4,FALSE),1)

Mike

"Wins07" wrote:

I have to analyse different products being sold in different regions, the
data are tabulated by products and by region. I have to extractthe best
selling product by region and overall.

The table is as follows:

desc Region1 Region2 Region3 Total
Prod A 2 5 6 13
Prod B 8 4 2 14
Prod C 6 2 7 15


Top Perf Prod B Prod A Prod C Prod C

Can anyone help me with a formula which would extract the top performing
product for each region and overall.

Looking forward to receiving your valuable help

Extracting top performing products by region
 

Thanks works out great


"Mike H" wrote:

I pasted the formula after I had dragged it, strat with this one and drag right

=INDEX($A$2:$A$4,MATCH(MAX(B2:B4),B2:B4,FALSE),1)

Mike

"Mike H" wrote:

Hi

try this in a cell and drag right. I have assumed your table is in A1 - E4

=INDEX($A$2:$A$4,MATCH(MAX(E2:E4),E2:E4,FALSE),1)

Mike

"Wins07" wrote:

I have to analyse different products being sold in different regions, the
data are tabulated by products and by region. I have to extractthe best
selling product by region and overall.

The table is as follows:

desc Region1 Region2 Region3 Total
Prod A 2 5 6 13
Prod B 8 4 2 14
Prod C 6 2 7 15


Top Perf Prod B Prod A Prod C Prod C

Can anyone help me with a formula which would extract the top performing
product for each region and overall.

Looking forward to receiving your valuable help