Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidating customer list for mailings
I use excel 2003 and am told I can consolidate my customer list. Currently
each sale has its own line, so my spreadsheet shows approx. 5100 lines when really I only have about 1200-1500 customers. iam trying to do a mailing and don't want to waste the labels or the time. Please Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidating customer list for mailings
A quick way to derive the required uniques listing of cust and address is via
creating a pivot Assume the relevant cust-address data is in C1:D5, viz: Cust Add Cust1 Add1 Cust2 Add2 Cust1 Add1 Cust1 Add1 where C1:D1 contains the col labels: Cust, Add The quick n easy steps to create the pivot (in xl2003): Select the range C1:D5, click Data Pivot table Click Next Next In step 3 of the wiz., click Layout, then: Drag n drop Cust into ROW area Double click on it, set subtotals to none ok Drag n drop Add into ROW area, below Cust Drag n drop Cust into DATA area (It'll appear as Count) Click OK Finish. That's it. Hop over to the pivot sheet (just to the left), where you'd find the required uniques listing of the Cust and Address in the leftmost 2 cols, eg: Cust Add Total Cust1 Add1 3 Cust2 Add2 1 (the 3rd col gives you the count, ie the number of sales transactions by each unique cust-add) Just copy Cust & Add portions, then paste special as values elsewhere as the source for your downstreams. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Snohogolf" wrote: I use excel 2003 and am told I can consolidate my customer list. Currently each sale has its own line, so my spreadsheet shows approx. 5100 lines when really I only have about 1200-1500 customers. iam trying to do a mailing and don't want to waste the labels or the time. Please Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating a Matching List | Excel Worksheet Functions | |||
Consolidating information from one sheet to a list on another | Excel Discussion (Misc queries) | |||
customer database for mailings and invoice analysis | Excel Discussion (Misc queries) | |||
Customer List Categorized | New Users to Excel | |||
To get customer list | Excel Worksheet Functions |