View Single Post
  #1   Report Post  
horatio
 
Posts: n/a
Default Count the frequency of all numbers in a column

I have a large column of numbers. I need to make a list of all the numbers
that are in that column and how often each appears. The result should be
three columns: original unsorted number list, list of numbers found, how
often each number is present in descending order.
I've tried COUNT, COUNTA, FREQUENCY, INDEX, MATCH and just can't get seem to
get it.
Much thanks to anyone who can help!!