Thanks Max - I'll give that try.
"Max" wrote:
If needed, for completeness
Then with the numbers: 1 - 9 listed in say N2:N10 ...
just expand the summary accordingly to include customers with no orders (all
zeros)
Then with the numbers: 0 - 9 listed in say N2:N11
Put in O2: =COUNTIF(L:L,N2)
Copy down to O11 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---