Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Greetings all,
I have a large spreadsheet that was exported out of my accounting program. It lists all customers and all their sales for the last 24 months. The total sales are listed below their individual sales, in the same column. Is there any way that I could sort this list by the total sales amount? The total sales are in bold, but no other customer data is on the same line. I need to come up with all customers that purchased over $3k in this time period. The number of sales vary by customer. Here is what the report looks like: Customer name Inv. # sale #1 Inv. # sale #2 ________ Total Sales Customer name Inv. # sale #1 €¦.. I am using Excel 2007. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Total then Sort | Excel Discussion (Misc queries) | |||
Calculate total $ based on rows displayed by sort | Excel Worksheet Functions | |||
sort by month with a monthly total | Excel Discussion (Misc queries) | |||
Sort And Total | Excel Discussion (Misc queries) | |||
Sort creating total errors | Excel Discussion (Misc queries) |