LinkBack URL
About LinkBacks
Hello. How does this formula work for counting unique values? Thanks. =SUM(IF(FREQUENCY(B5:B54848, B5:B54848)>0,1))
Hello. How does this formula work for counting unique values? Thanks. =SUM(IF(FREQUENCY(B5:B54848, B5:B54848)>0,1))
- Count the number of unique values by using the FREQUENCY function. The FREQUENCY function ignores text and zero values. For the first occurrence of a specific value, this function returns a number equal to the number of occurrences of that value. For each occurrence of that same value after the first, this function returns a zero.
- Assign a value of 1 to each true condition by using the IF function.
- Add the total by using the SUM function.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks