bradrob wrote:
I wonder if anyone has tried this before i have a large spreadsheet of
numbers which i need to find the most common numbers that appear in the
tabel so i am looking for a formula that will calculate one column at a
time.


Any help would be appreciated.

Thanks
Brad


Expanding on my original reply...

You need to first load the analysis toolpack by going to tools / Add-ins
and selecting "Analysis Toolpack"

Then you need to follow instructions under Tools | Data Analysis |
Histogram.

Before it will generate the histogram, you need to indicate the size of
the bins into which the data tallies are to be placed. For example, a
table showing 100, 1000, 10000 would have three bins, for number of
occurances of under 100, for number of occurances over 100 by under 1000
, and so on.