
www.Usenet.com
Group Index
Comp Thread Archive from Usenet.com
Help needed with analysing a column of data
- __From__: Nigel
- __Subject__: Help needed with analysing a column of data
- __Date__: Tue, 18 Nov 2003 08:31:26 -0600
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
- Help needed with analysing a column of data,
Nigel