EXCEL: Getting Average/Most Popular

[wookie]

I have created a spreadsheet with column A having a date, columns B-G having specific numbers and column H having the SUM of B-G of the specific row.

What I cant figure out is

1. A formula to calculate which number shows up most often, a ranking of how often each number shows up
2. Same as above except for specific columns (b,c,d,e,f,g)

Any help/Input appreciated :)

[sumfunny]

shows up most often =mode(#,#,#)
number of times shown =countif()

[wookie]

shows up most often =mode(#,#,#)
number of times shown =countif()

could you give me an example if data is in range b2:g101. thanks

[kaddy69]

Do you know how to program at all? If so, you can do it in VBA (visual basic for applications).

kaddy69

[wookie]

i figured it out with the countif and mode commands... thanks