Find Inactive
use advanced filter, set the criteria to sales date zero.
"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
------=_NextPart_000_008C_01C713FD.35636AF0
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Google-AttachSize: 915
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
<HTML<HEAD
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1"
<META content="MSHTML 6.00.3790.2759" name=GENERATOR
<STYLE</STYLE
</HEAD
<BODY bgColor=#ffffff
<DIV<FONT face=Arial size=2I 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.</FONT</DIV
<DIV<FONT face=Arial size=2</FONT </DIV
<DIV<FONT face=Arial size=2Krish</FONT</DIV</BODY</HTML
------=_NextPart_000_008C_01C713FD.35636AF0--
|