with your data in A1 through A10
enter into a cell
=sum(if(frequency(a1:a10,a1:a10)>0,1))
but enter it with ctrl+shift+enter
as it's an array funciton. You know this worked because gnumeric (and excel
does the same) displays the formula in {curly braces}
You must actually be editing the forumula for ctrl+shift+enter to work.
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.
On 11 October 2013 07:41, Sardo_Numpsa <[email protected]> wrote:
> 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
> [email protected]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
