Navigation: Home General Random Counting Unique Values in Excel
Counting Unique Values in Excel
General - Random
Wednesday, 09 February 2011 16:03

Ran into a situation this afternoon whereby I needed to count the number of unique values in a column.

Since I find myself working in Excel, I went about searching for a solution to this.

AND... here you have it.. A quick and easy formula for working out the number of unique records in a column.

=SUM(IF(FREQUENCY(D2:D13824, D2:D13824)>0,1))
Use it wisely ;-)

 

Twitter Feed

reegz786
Java developer with delusions of Flex.. Living the developers dream
reegz786
reegz786: Just got asked if I've ever heard about the Balanced Scorecard. @CubicThoughts

12 hour(s) ago from Twitter for Android

reegz786
reegz786: #Ubuntu now on #android #linux #ftw http://t.co/LEsOc6v9

12 hour(s) ago from Twitter for Android

reegz786
reegz786: Never do business with friends.

2 day(s) ago from Twitter for Android



powered by TweetXT!