Thread: Formula to count distinct values not working in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALATL ALATL is offline
external usenet poster
  
Posts: 24
Default Formula to count distinct values not working in VBA
It need to count unique TEXT values in a column. Sorry for the typo. :-)

"ALATL" wrote:

I have this formula that works perfectly in Excel. It counts the unique
values in a column. But it does not work in the VBA editor. Does anyone have
any ideas?

Count = SUMPRODUCT((C6:C39<"")/COUNTIF(C6:C39,C6:C39&""))
Reply With QuoteReply With Quote