| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display data in series
I have a sheet containing data as following:
Date Code Product Transaction on Qty 21/2 12 Ink Purchase 20/2 30 28/2 11 Ballpen Sales 27/2 25 2/3 12 Ink Sales 1/3 20 5/3 11 Ballpen Return 4/3 12 6/3 11 Ballpen Sales 5/3 9 13/3 12 Ink Sales 11/3 10 I then wish to have a result in other sheet as following : When the code 12 is entered : Code : 12 Product: Ink 21/2 Purchase 20/2 30 2/3 Sales 1/3 20 13/3 Sales 11/3 10 when the code 11 is entered, the results relating to Ballpen is listed. How to set ? I wish to have the table list in the other sheet and not using filter in the same data sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I display 2 data series with different starting dates | Charts and Charting in Excel | |||
| Graph with 2 X axis - data series display limit? | Charts and Charting in Excel | |||
| How do I display the sum of 2 data series on a column chart? | Charts and Charting in Excel | |||
| prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Threaded Mode
