Unique Values

[nevillestoke]

I downloaded the morefunc.xll which was referenced in an earlier thread - and while I don't need to use the uniquevalues function yet, it looks like a useful one for future reference.

The function syntax is {=uniquevalues(array,order)}

However, when I use it, the results I get are not unique - in fact, even in the description and example that comes with the download, the results are not unique.

Let's see if I understand the function correctly:

You can assess a range reference (or several other options) to determine if a unique item appears in the range.

The example provided states that the range "PL" contains

54,22,92,54,4,71,54,54,38,66,92,31 and 4

and the function: {=uniquevalues(PL)} returns {92;71;66;54;387;31;22;4}

When I try to replicate this, the result I get is 4

Aren't both results incorrect? If the function is supposed to provide unique values, shouldn't the above use of the function return 71,66,38,31,22?

I am entering this as an array formula - using CTRL, SHIFT, ENTER but cannot understand the results.

Any one know where I am going wrong - or is my understanding faulty?

As noted - this would be helpful for many future sheets I will be creating.

Neville.

 

[Juan Pablo González]

It works just fine for me...

When you enter

=UNIQUEVALUES(PL)

and press F9, what do you see in the formula bar ?

 

[nevillestoke]

When I press F9, I get the result listed in the example that was provided with the function (F9 b- obviously, something else I did not know about) - the result is

={92;71;66;54;38;31;22;4;"";"";"";"";""}

but, should 92 not be on the list, as it does appear more than once?

Thanks for the quick response.

Neville.

 

[nevillestoke]

Sorry- my error

I see now that the function is only returning one result of 92, 54, etc.

Thanks again

Neville

 

[Aladin Akyurek]

...
but, should 92 not be on the list, as it does appear more than once?

Thanks for the quick response...

Unique means distinct. Since 92 is a distinct value, it should appear in the result list.