The OP emailed his sheet directly to me last night (without
asking !!), so I put the formula in there and sent it back to him.

Pete

On Apr 9, 3:48*pm, ryguy7272
wrote:
Take a look at this:http://peltiertech.com/Excel/Pivots/...07.html#Unique

Regards,
Ryan--

--
RyGuy