| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick list location
I have a set of data with 10000 row
Div Market salesman Factor Result 1599 1501 John sales R 1599 1501 John Profit G 1599 1501 John GP% Y 1599 1501 Jeff sales R 1599 1501 Jeff Profit Y 1599 1501 Jeff GP% Y 1699 1601 Robert sales Y 1699 1601 Robert Profit G 1699 1601 Robert GP% R 1699 1601 Ron sales Y 1699 1601 Ron Profit G 1699 1601 Ron GP% R 1799 1602 Susan sales Y 1799 1602 Susan Profit G 1799 1602 Susan GP% Y 1799 1602 Sweet sales Y 1799 1602 Sweet Profit G 1799 1602 Sweet GP% Y How can the user when they pick or use slice scale it will get back Div and Market Div Market -------- pick list 1599 1501 Factor John Jeff sales R R profit G Y GP% Y Y Thank liem -- thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pick up file from specific location | Excel Discussion (Misc queries) | |||
| Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
| Pick value at intersection of location & date (MMM-YY) | Excel Worksheet Functions | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| Pick From List | Excel Discussion (Misc queries) | |||
Threaded Mode
