Re: Count unique occurences of values

with your data in A1 through A10

enter into a cell

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 <aspeich gmail com> wrote:

I have a bunch of unique numbers in a column and want to count the number of
unique occurrences, for example:


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:


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?


View this message in context:
Sent from the GnuMeric mailing list archive at
gnumeric-list mailing list
gnumeric-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]