Filter out unique records from pivot

H

Hile

Win2K Prof
Excel 2k3 SP2

I have a table that looks like this with over 55,000 rows:
Dist Nbr Customer Acct Nbr Customer Number Bill-to Company Name Bill Grp
7510 60000100 600001 SUMTER PACKAGING CORPORATION 00
4611 60000200 600002 A SMOOTH MOVE LLC 00
0670 60000300 600003 AIMET TECHNOLOGIES INC 00
0405 60000400 600004 ATLANTIC PLANT SERVICES INC 00
0548 60000500 600005 R AND R CARTAGE INC 00
0550 60000600 600006 ACCURATE RESPONSE INC 00

I need 3 separate lists from this raw data,

1. List of Cust_Numbers with multiple Bill_Groups per Customer number
2. List of Cust_Names with multiple Cust_Numbers
3. List of Cust_Nos with multiple Bill_Groups with a unique Cust_Name per
Bill_Grp

I setup all my pivots but I don't want the unique records and I can't figure
out how to take those out. Any takes?!!!!

I need this fast, short deadline, going crazy... :-0
I posted on Mr. Excel weeks ago and no response.

Thanks so much.
 
H

Hile

I forgot to add, I can do a count and filter for records >1 but given how I
want the data to show, this is not possible (or at least I can't think of a
way). For example in the first list I have the following (this is how I want
it to show):

Bill-to Company Name Customer Number Bill Grp Total
1055034 ONTARIO INC 698004 00 1
04 1
1083262 ONTARIO INC 698112 00 1
02 1

This gives me Cust_Numbers with multiple Bill_Groups per customer. I can
move the Bill Group field into the Data section as a Count and remove it from
the row area, then filter out total=1 but I get the following:

Bill-to Company Name Customer Number Total
1055034 ONTARIO INC 698004 2
1083262 ONTARIO INC 698112 2
1150420 ONTARIO INC 698204 2

I need the actual Bill Groups listed as pasted in the first paragraph and as
such filtering for >1 doesn't yield the desired output.
 

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

Top