View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smandula smandula is offline
external usenet poster
 
Posts: 116
Default Reverse Frequency

Need to list the individual frquencies for each Number
i.e.
Number Frequency
1 10
2 7
3 11
4 5
5 3
6 6
7 8
8 9
9 9
10 9
11 7
12 10
13 5
14 5
To Look like the following.

Frequency
3 5 7 8 9 10
------------------------------------------
5 4 2 7 8 1
13 11 9 12
14 10

A reverse frequency with individual lookup in ascending order.

Any suggestions would be appreciated.

With thanks