Krish,

One way to do it is to add a column to your master data, here I put it in
column C
and in cell c2
=IF(countif(Pivot!A:A,A2)0,"Sales","No Sales")
and copy it down all the master record rows
put a title in the c1 as "Sales"
then use auto filter and select 'No Sales' for column c.

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Krish" wrote:

I have a spreadsheet with two worksheets. The first worksheet is a Pivot table with Rows "CustomerID", Column "SalesRep" and the data is Sales for 2006. The second spreadsheet is Customer Master file with "CustomerID" and "SalesRep". I want to find out which customer did not buy during 2006. I am looking for a formula to produce minimal data. The Customer Master is 3000 rows, while the Pivot table has only 932 rows. Any help is truly appreciated