LinkBack URL
About LinkBacks
I use the following formula to count the number of unique values:
={SUM(1/COUNTIF(Range;Range))}
This one works as far as there aren’t any blank cells. The result is then: #DIV/0!
How could I construct the formula to ignore blank cells?
Saturn
I use the following formula to count the number of unique values:
={SUM(1/COUNTIF(Range;Range))}
This one works as far as there aren’t any blank cells. The result is then: #DIV/0!
How could I construct the formula to ignore blank cells?
Saturn
Last edited by Saturn; 04-09-2012 at 10:19 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks