Find Inactive

  • Thread starter Thread starter Krish
  • Start date Start date
K

Krish

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.

Krish
 
use advanced filter, set the criteria to sales date zero.
"Krish дµÀ£º
"
 
You could add a formula in a column on the Customer Master sheet.

For example, with customer names in column B:

=IF(COUNTIF('PivotSheet'!C:C,A2),"","Inactive")

would check for matching customer names in the pivot table (column C)
 
Thank you so much Debra. Your formula helped me to produce the results I needed to see.
You could add a formula in a column on the Customer Master sheet.

For example, with customer names in column B:

=IF(COUNTIF('PivotSheet'!C:C,A2),"","Inactive")

would check for matching customer names in the pivot table (column C)
 
You're welcome. Thanks for letting me know that it helped.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not sure which function to use - need multiple lines of data 1
Using a Worksheet Name in a Formula - XP or 2007 1
Subtotal Function - add formula to all blank rows 1
Update Filter List AFTER Filter Applied 3
identifying data from a separate worksheet 1
Macro to copy specific data from master workbook to another workbook 13
SUM formula help PLEASE??? 4
calculating differences in a pivot table 3

Back
Top