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. _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
