Counting Unique Values in A column

I

ibeetb

I need to count the unique (non-duplicate) values in a column range.
Does anybody know an Excel or VBA function to do this?
 
K

Ken Wright

=SUM(1/COUNTIF(A1:A1000,A1:A1000))
(Array Entered - CTRL+SHIFT+ENTER)

or

=SUM(N(FREQUENCY(A1:A1000,A1:A1000)>0))
(Array Entered - CTRL+SHIFT+ENTER)
(Numbers only in a mix of numbers & Text)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
countif - unique values only 13
Delete 100 Hundred Unique Values From Word Document 0
Remove Identical words 0
Duplicate entry in a column/row 14
Remove Duplicates (Macro) 8
Counting unique values in multiple columns 4
Fill cells based on the other 3 cells unique combination the value on the target cell 0

Top