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