Thread: a twist on counting unique values in a range which contains blankcells, using a formula. the formula can't use SUMPRODUCT or FREQUENCY
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default a twist on counting unique values in a range which contains blank cells, using a formula. the formula can't use SUMPRODUCT or FREQUENCY
Hi Pete,

Am Thu, 4 Aug 2016 06:24:17 -0700 (PDT) schrieb pete:

I need a formula, not VB code, to count the number of unique values in a column of up to 10,000 rows, some of which will be blank. The values may be numeric, alphanumberic, or text.

try:
=SUM(IF(A1:A36<"",1/COUNTIF(A1:A36,A1:A36)))
and insert the formula with CTRL+Shift+Enter


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote