Return to article: How to Find the Number That Appears Most Frequent in a Column in Excel
on 12/11/2007 Ok, I guess I have too much time on my hands :^). I hope I'm not bugging you, and this may sound stupid to you, but here goes. What I'm doing is a lottery spreadsheet. Every day I enter that day's drawing. It's a 5 number lottery, so there's 5 columns of numbers. I want to find which number appears the most from each column. I froze the 5 columns so when I do the data sort, it doesn't screw up what I have. I copied and pasted the 5 columns into the unfrozen part of the sheet. Then I do the Data filter. All I'm looking for is one number that appears the most in the column. Is there a way to get just one number instead of a list of numbers? Like you had 11 as the number that appeared the most, but it gives every instance of the number 11. Know what I mean? By-the-way, I use Open Office Calc, but it's very similar to Excel.
Copyright © 1999-2008 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.
Partner Sites
