Tested in gnumeric 1.10.10 on centos 6 but I'm pretty sure any gnumeric of the past 8 or 9 years will work just as well.You must actually be editing the forumula for ctrl+shift+enter to work.as it's an array funciton. You know this worked because gnumeric (and excel does the same) displays the formula in {curly braces}but enter it with ctrl+shift+enter=sum(if(frequency(a1:a10,a1:a10)>0,1))with your data in A1 through A10enter into a cell
On 11 October 2013 07:41, Sardo_Numpsa <[hidden email]> wrote:
Hi,[hidden email]
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
https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
If you reply to this email, your message will be added to the discussion below:http://gnome-apps.13852.n7.nabble.com/Count-unique-occurences-of-values-tp64451p64452.html