Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Supplier Location Sales
Supplier-A BX1 10 Supplier-A BX2 3 Supplier-A BX3 2 Supplier-A BX4 9 Supplier-B BX5 11 Supplier-B BX6 2 Supplier-B BX7 7 Supplier-B BX8 1 Supplier-C BX9 22 Supplier-C BX10 4 Supplier-C BX11 5 Supplier-C BX12 9 Supplier-C BX13 3 Summary Report Top Sales Location Supplier-A Supplier-B Supplier-C I want to see Top sales as 10 and Loacation as BX1 against supplier-A in the summry repoty. How do I achieve this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I lookup a corresponding value in another table | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
lookup a value on a table | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Lookup Table | Excel Worksheet Functions |