Thread: For each change in Col. C, Count Unique Numbers in Col. G
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default For each change in Col. C, Count Unique Numbers in Col. G
=SUMPRODUCT((C1:C100<"")/COUNTIF(G1:G100,G1:G100&""))


"ryguy7272" wrote:

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?

Thanks,
Ryan---

--
RyGuy
Reply With QuoteReply With Quote