Thread: Counting Unique Alpahnumeric's in a list
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 Counting Unique Alpahnumeric's in a list
=SUMPRODUCT((A1:A110<"")/COUNTIF(A1:A110,A1:A110&""))


"aspenelk" wrote:

I have huge column of alphanumeric data, some duplicated in different lines.
I need to be able to count or sum the unique entries?

Thanks, R. Rhoden
Reply With QuoteReply With Quote