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


seems to me that you want to construct a histogram. I believe Excel has
a built in histogram routine.