pivot table showing specific criteria

[bzl]

I have a main table listing the following:
SalespersonID, SalesDate, ProductID
11, 01/01/13, aaa
11, 01/01/13, bbb
22, 01/02/13, aaa
22, 02/02/13, bbb
22, 03/02/13, ddd
33, 04/04/13, aaa
44, 05/05/13, eee
55, 04/04/13, aaa
55, 04/04/13, bbb

I did a pivot table with the rows being SalespersonID and SalesDate and the column heading as ProductID and the value as ProductID (count).
I need to eventually see only Product Id of both aaa and bbb for a Salesperson on the same date. I can see the results in a basic pivot table if you scroll down looking for the results but I want to see the results without scrolling down looking for them. I know you have to put a formula in the source data, i don't know where to start. In this example I would want to see SalespersonID 11 and 55 who both have aaa and bbb on the same date.

[:) Sixthsense :)]

Please attach a sample workbook with expected output for better understanding

[bzl]

Hi, I have attached the file as requested, hope you can help...

[:) Sixthsense :)]

Not sure what is your expected outcome

[bzl]

like i said in my inital question, I want to see only those salespersons who had aaa and bbb on the same day shown in a pivot table

[:) Sixthsense :)]

Please refer the attached excel file for solution

[bzl]

Hi, Thanks Sixthsense, that is exactly what I wanted....I am going through your formula, can I ask you why you repeated "aaa" i.e. C5="aaa","bbb","aaa").......thanks in advance.

[:) Sixthsense :)]

Oops... error in suggested formula

In D2 Cell

Please Login or Register  to view this content.

Drag it down...

[bzl]

Hi, I would never have noticed the difference. I copied your corrected formula and got the same result....have never used the little arrow heads before...will have to read up on them.....Thanks again....your help was appreciated...

[:) Sixthsense :)]

To know the difference download the file from Post #6, place the cursor in C3 cell and delete the cell content, still the formula will display the result as SHOW in D3 cell.

Apply the formula suggested in Post #8 in D2 cell and drag it down.. Now you can see the difference

[bzl]

Hi,....Now I see...makes a lot of difference...so much to be aware of in Excel....thanks for the lesson.