Forum Discussion
Counting unique words while counting duplicates as one
Hi, What formula can I use to count unique values while counting duplicates as one. For example: apple, apple, apple, banana, banana, orange, plum should produce a number of 4. Thank ...
No, all my values are there, all are words, no zeros or blanks. I am not using Excel 365 is that the issue?
The UNIQUE function works only with Office 365 or Excel 2021 or Excel for the web.
=SUM(1/COUNTIF(AN3:AN273,AN3:AN273))This formula works in older versions e.g. in Excel 2013 if you enter it with ctrl+shift+enter. I've attached a sample file where you can see the result.