Thread: Count unique if text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Fogleman Mike Fogleman is offline
external usenet poster
  
Posts: 1,092
Default Count unique if text
Column B has a mix of text and numbers. I want to count unique text values
only.
The answer to the following list would be 8.

P2-2
P2-2
P2-7
P1-3
P-HE
P2-7
6
P11-2
P12-8
P12-8
P12-1
P12-1
P11-3



Mike F


Reply With QuoteReply With Quote