On Dec 22, 5:16*pm, "Don Guillett" wrote:
One way may be to use datafilteradvanced filterunique to make a unique
list and then loop thru that list.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"runsrealfast" wrote in message


The trouble with that is that the use would then have to copy and past
for each department, and there is about 200 or so. However, I guess I
could do it once and record or write a macro and it would just work
that way.