| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying to consolidate info into one sheet
I am trying to do a report showing total sales for about 200 customers,
showing month by month, on one sheet. The numbers are imported from a program that lists the customers by number of units from high to low, and only does one month at a time. The problem is the sales vary so is there a way to match them up with out doing it manually? Example: January Customer A has 100 units Customer B has 50 units Customer C has 10 units. The next month Customer B has 50 units Customer A has 25 units Customer D has 16 units Customer C has 0 units. So each month may have a new customer, and the ranking will vary. Help! thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to consolidate info into one sheet
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| consolidate info | Excel Worksheet Functions | |||
| Consolidate information from Column B Based on Info In Column A | Excel Worksheet Functions | |||
| Consolidate multiple worksheets into new sheet | Excel Worksheet Functions | |||
| Can I consolidate one work sheet from several workbooks? A few oth | Excel Discussion (Misc queries) | |||
| consolidate values to a checklist on sheet 2 | Excel Discussion (Misc queries) | |||
Linear Mode
