Thread: Histogram
View Single Post
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

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