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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick list location
I don't completely understand your question, but perhaps a PivotTable would
work for you? Your initial criteria of picking Div and Market could be setup as page fields, thus filtering the data you want to look at. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "liem" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick list location
This seems to call out for Data|Filter|Autofilter.
You can use the dropdown arrows to choose and then only the rows that match your criteria will be visible. liem wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick list location
I do not want to use Pivot . The example I gave to you only have 2 saleman
but if division 1599 market 1501 have 20 saleman and other 8 divisions will have more market and more saleman. How can i turn these data to Cross tab with the user be able pick a Division-market it will show Factor John Jeff Robin Diane Howard Scott ------------more salesman sales R R G Y G G profit G Y Y Y Y Y GP% Y Y R R R R -- thanks "liem" wrote: I have a set of data with 10000 row with 8 division and 64 market and 740 saleman sample data 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 |
Reply |
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) |