| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA determine computer region | Setting up and Configuration of Excel | |||
| Region | Excel Discussion (Misc queries) | |||
| need to zoom in a particular region of graph | Charts and Charting in Excel | |||
| Is it possible to count if within a number region? | Excel Discussion (Misc queries) | |||
| how to shrink a region (because of a maverick) | Charts and Charting in Excel | |||
Linear Mode
