ExcelBanter - countif not the same

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - countif not the same (https://www.excelbanter.com/excel-discussion-misc-queries/167946-countif-not-same.html)

Andrew@rushington[_2_]

countif not the same

can i use countif to count the how many different values exist in a column.

RichardSchollar[_2_]

countif not the same

On 30 Nov, 10:06, Andrew@rushington
wrote:
can i use countif to count the how many different values exist in a column.

Assume Col A you want to count a list of uniques (excluding blanks)
within A1:A1000:

=SUMPRODUCT((A1:A1000<"")/COUNTIF(A1:A1000,A1:A1000&""))

Richard

All times are GMT +1. The time now is 03:21 PM.