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.
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.