I have a list of names in Column C and a list of duplicate and/or unique IDs
in Column G. I'm trying to find a way to count all unique numbers in Column
G, for each person listed in Column C (data is sorter by Column C). Any
ideas?

I posted in the Excel - Functions area earlier, and TM provided this solution.
=SUMPRODUCT((C1:C100<"")/COUNTIF(G1:G100,G1:G100&""))

I think this will work, but my data set is quite large and Excel runs very
slow when I implement this solution (and I'm only using the function on 1/5
of the data). There must be a better way of doing this, right.

Thanks,
Ryan---


--
RyGuy