Glad to help ... BUT,

Beside using that pot of coffee to help reading up on newsgroups,
Grab another one and spend time at Debra's web site, Pivot Tables

I previously gave you the link.
Here it is again:

http://www.contextures.com/tiptech.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Bill" wrote in message
...

Well you're better than you give yourself credit for. I
just tried this and it worked as advertised. I then
tried it with letters instead of numbers for the work
orders (just for fun) and that really does NOT work - as
I've said before, it seems that the data must be numbers
to be returned properly. So your idea works great for me
because the work order numbers are, in fact, numbers.
Thanks for your persistence!