Count unique occurences of values
- From: Sardo_Numpsa <aspeich gmail com>
- To: gnumeric-list gnome org
- Subject: Count unique occurences of values
- Date: Thu, 10 Oct 2013 13:41:44 -0700 (PDT)
Hi,
I have a bunch of unique numbers in a column and want to count the number of
unique occurrences, for example:
1
2
3
3
4
will return 4.
The below apparently work in Excel (don't have Excel so not tried myself),
but are not working for me in Gnumeric:
=SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))
SUMPRODUCT(1/COUNTIF(B5:B15,B5:B15)).
The first returns 1, and the second returns numbers less than 1, which
obviously is not right.
Anybody have any ideas on how I can get this to work in Gnumeric?
Thanks
--
View this message in context:
http://gnome-apps.13852.n7.nabble.com/Count-unique-occurences-of-values-tp64451.html
Sent from the GnuMeric mailing list archive at Nabble.com.
[Date Prev][
Date Next] [Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]