| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering data to include values only if x and y exist
Excel 2003
Hope somebody can help with the following. I have information x and y in the same column concerning A (persons)in a pivot table. I would like to show information x and y per person only if x and y both have a value. If x or y doesnt have a value then the person in question should not be shown in the report. I am not sure if pivot table is the best tool for this, but I do not know of any other better tool. Ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering out single values (keeping only repeating data) | Excel Discussion (Misc queries) | |||
| Calculate average and not include zero values | Excel Discussion (Misc queries) | |||
| Returning the desired value if multiple values exist???? | Excel Worksheet Functions | |||
| Ascertaining whether external data sources or hyperlinks exist | Excel Discussion (Misc queries) | |||
| Do the values in a range of cells include all members of a set? | Excel Discussion (Misc queries) | |||
Threaded Mode
