I think the CountIf function is what you're looking for.
HTH,
Gary Brown


"Jorge" wrote:

Hi

I need to count the number of unique text values stored in column A based on
the contents of column B. Column B contains groups of values of different
sizes (# rows) for each group I need to count the number of unique
corresponding values stored in column A. These are all text based.

Any suggestions on how to do this?

Thanks,
Jorge