List of different values in data area

[balcovja]

Hi excel specialists,

How Can I automatically get the list of different values from the data area and to find out their frequence?


INDIVIDUALLY MEASURED VALUES:
3,5 4 3,5 4 3 3,5 4 4 3
3,5 4 3 3,5 3 3 3,5 4 4

Thanks for your help in advance. Balcovja.

[Bob Phillips]

Take a look at FREQUENCY in Hep

--

HTH

RP
(remove nothere from the email address if mailing direct)


"balcovja" <[email protected]> wrote in
message news:[email protected]...
>
> Hi excel specialists,
>
> How Can I automatically get the list of different values from the data
> area and to find out their frequence?
>
>
> INDIVIDUALLY MEASURED VALUES:
> 3,5 4 3,5 4 3 3,5 4 4 3
> 3,5 4 3 3,5 3 3 3,5 4 4
>
> Thanks for your help in advance. Balcovja.
>
>
> --
> balcovja
> ------------------------------------------------------------------------
> balcovja's Profile:
http://www.excelforum.com/member.php...o&userid=26239
> View this thread: http://www.excelforum.com/showthread...hreadid=395728
>