Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Help needed with analysing a column of data



Hi,

I have a column of numbers most of which are repeated several times eg

0.146
0.551
0.551
0.516
0.141
-1.662
0.141
0.551
0.551
0.146
0.516
0.551
0.141
0.324
-1.102
0.146
0.551
0.146
-1.662
0.516
0.516
0.141
0.141
0.516
0.551
0.146
0.141
-0.491
0.141
-0.011
0.516
-1.662
-1.102
-0.491
-0.011
0.706
0.551
0.630
0.141
2.174
-0.491
-1.102
-1.662
0.141
0.630
0.141
0.551
-0.011
0.141

I want to generate two columns of data from it - the first column is a list of the discrete values in descending order, the second column is a count of how many times that value occurs eg

2.174   1
0.706   1
0.630   2
0.551   9
0.516   6
0.324   1
0.146   5
0.141   11
-0.011  3
-0.491  3
-1.102  3
-1.662  4

I'm not using Excel so a VB solution isn't any use to me, but I can probably translate Excel macros without too much trouble.

Thanks for your help,

Nigel




<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.