If your numbers are in column A ( say A1:A100 )then =MODE(A1:A100) will give
you the most common number.
--
Gary's Student
"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
--
bradrob
------------------------------------------------------------------------
bradrob's Profile: http://www.excelforum.com/member.php...o&userid=29120
View this thread: http://www.excelforum.com/showthread...hreadid=488401