Unique Values

[aabbasi]

I have added the following addin: MoreFunc from
http://longre.free.fr/english/index.html,

There is a function called {=UNIQUEVALUES(Array,Order)}. My problem is that it is not giving the list of Unique values instead it is showing only one Value. Does anyone has experience working with this in Excel 2000.

Thank you.

Eg: Values 23,23,45,34,32 should show 45,34,32,23 but instead of this it is showing 45 only.

 

[aabbasi]

David Patton:

Thank you very much for your wonderful solution. It works for me.

regards,

 

[Aladin Akyurek]

On 2002-10-30 17:02, aabbasi wrote:
David Patton:

Thank you very much for your wonderful solution. It works for me.

regards,

That solution is exactly what I had in mind -- combining UNIQUEVALUES with INDEX, the link I quoted shows how it's done! I thought you didn't want that multi-cell expansion, hence the single cell proposal... A case of miscommunication I guess.

 

[aabbasi]

Aladin: I apologize for misunderstanding.

Thanks