I use Jim Cone's fine commercial Add-in called XLCompanion for tasks like
this. It's available at
www.realezsites.com/bus/primitivesoftware/
vaya con Dios,
Chuck, CABGx3
"Mark" wrote:
...into a single occurance. I have 1 sheet that can have multiple text
(Client) entries, duplicates permited. On another sheet I would like to see
each text entry only once. I'll use this "field/result" with a sumproduct to
determine total items by Client.