Not if you've hit that limit. Stick with Pete's solution.

Regards
Ken................

"lingo" wrote in
message ...

I tried the pivot table, but I keep getting an error saying column A
contains too many unique items... any suggestions on how to get around
that?


--
lingo
------------------------------------------------------------------------
lingo's Profile:
http://www.excelforum.com/member.php...o&userid=32315
View this thread: http://www.excelforum.com/showthread...hreadid=520703