Thanks mate!
On 11 October 2013 11:29, Hal Ashburner [via Gnome - Apps] <
[email protected]> wrote:
> 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 <[hidden
> email]<http://user/SendEmail.jtp?type=node&node=64452&i=0>
> > 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
>> [hidden email] <http://user/SendEmail.jtp?type=node&node=64452&i=1>
>> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>>
>
>
> _______________________________________________
> gnumeric-list mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=64452&i=2>
> 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
> To unsubscribe from Count unique occurences of values, click
> here<http://gnome-apps.13852.n7.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=64451&code=YXNwZWljaEBnbWFpbC5jb218NjQ0NTF8MzcwOTk2NTI=>
> .
> NAML<http://gnome-apps.13852.n7.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context:
http://gnome-apps.13852.n7.nabble.com/Count-unique-occurences-of-values-tp64451p64453.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
