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?