Thanks for the pivot table suggestion. That would work but this will be a small part of a larger vba procedure.