MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to identify new entries weekly and pull totals from pivot table?

Posted by Brad on August 02, 2001 10:57 AM

I have a workbook that has 3 worksheets. One is a master list of customers and jobs we have done for them. Another is a pivot table that lists the customer and a count of the number of jobs we have done for them. The last is a sheet with the new weeks data (which will be combined into the master list next week). I want to be able to tell how many new customers we have each week, total customers (ytd), what the percentage of new customers is (total), and what percent of one time customers we have (total). I don't know what the easiest way to do this would be.
please help

Posted by Mark W. on August 03, 2001 12:36 PM

Why don't you combine the new data with the old
and add a column ('Entry Date'?) to differentiate
between new and old?