G'day Horatio,
I employ this query state, constantly in my Thoroughbred Spreadsheet.
I copy and paste Data to an MSWorks Database ($10 ebay)
with a dedicated simple "Report" set up,
which is about a six click procedure.

I just post this as FYI, in case you may be interested in workarounds.
The only downside being Works has only 30,000 records parameter.




"horatio" wrote in message
...
| 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!!
|