« Spelling out numbers | Main | Summing across sheets »
August 24, 2005
Counting unique entries in a range
A good source of hints and tips for OOo Calc can be the numerous Excel blogs. One of the best is from Dick Kusleika.This formula for counting the number of unique items in a range of cells was one of three suggested by Dick - but the only one that ported successfully to OOo Calc.
It is an array formula. Use Ctrl-Shift-Enter when entering it.
=SUM(IF(FREQUENCY(IF(LEN(A1:A10)>0;MATCH(A1:A10;A1:A10;0);""); IF(LEN(A1:A10)>0;MATCH(A1:A10;A1:A10;0);""))>0;1))
where A1:A10 is the range being analyzed..
Posted by Dave at August 24, 2005 09:47 PM
Comments
I will remember this blog as the place that helped me get through my first day of using a spreadsheet!
Thanks!
Posted by: Michaël at August 28, 2005 10:09 AM