I'd use data|filter|advanced filter.
Copy the unique records to a different location and sort that range.
Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xladvfilter01.html#FilterUR
durino13 wrote:
So according to this, the only way, how to force excel to take proper
values is to explicitly write down the bin array ...
So my second question is, how can I find out the sorted array of
values, where the values will be unique and sorted?
Something like this:
I have an array: 1 3 5 7 10 10 1 3 2
The result should be like this: 1 2 3 5 7 10, it means sorted and
unique ...
Is there a function for this?
--
durino13
------------------------------------------------------------------------
durino13's Profile: http://www.excelforum.com/member.php...o&userid=26334
View this thread: http://www.excelforum.com/showthread...hreadid=396043
--
Dave Peterson