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