| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate how many customers take SKU's
Hi Max
Thanks everyone and will do Des "Max" wrote: Des, Glad you got that working. Please put in your new query as a fresh posting -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- Des wrote: Hi Max Okay - now that I have this done, I know need to calculate what the ave no of units is by no of SKU's taken. My reports reads like this 52000 52001 52002 52003 | 52000 52001 etc Ave Cust No Name Count | Units Units 111 Co A 20 10 0 30 | 12 36 24 112 Co B 10 0 20 5 | 144 216 180 etc So, having calculated per your suggestion, I need to calc what the ave units per "how many customers take 1 SKU, 2 SKU's etc" is. I'd be happy to send an excerpt of the spreadsheet, if that would help. Any advice would be greatly appreciated. Thanks Des |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't get excel to calculate | Excel Worksheet Functions | |||
| any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
| Auto Calculate | Excel Discussion (Misc queries) | |||
| Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
Threaded Mode
