| 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 |
| 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 | |||
Threaded Mode
