Search Forums
shows up most often =mode(#,#,#)
number of times shown =countif()
-
May 16th, 2005 08:33 PM #1
EXCEL: Getting Average/Most Popular
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
Reply With Quote
LOG IN TO THANK
No one has yet thanked wookie for this post.
-
Sponsored Links - Join the RedFlagDeals.com community and remove this ad.
-
May 16th, 2005 08:43 PM #2 Reply With Quote
LOG IN TO THANK
No one has yet thanked sumfunny for this post.
-
May 17th, 2005 06:18 AM #3Deal Addict
[OP]
- Join Date
- Jan 14th, 2004
- Location
- London, ON
- Posts
- 3,054
could you give me an example if data is in range b2:g101. thanks
Originally Posted by sumfunny
Reply With Quote
LOG IN TO THANK
No one has yet thanked wookie for this post.
-
May 17th, 2005 12:14 PM #4
Do you know how to program at all? If so, you can do it in VBA (visual basic for applications).
kaddy69_______________
MY HEATWARE - Available upon request
MY EBAY - Available upon request Reply With Quote
LOG IN TO THANK
No one has yet thanked kaddy69 for this post.
-
May 17th, 2005 12:21 PM #5Deal Addict
[OP]
- Join Date
- Jan 14th, 2004
- Location
- London, ON
- Posts
- 3,054
i figured it out with the countif and mode commands... thanks
Reply With Quote
LOG IN TO THANK
No one has yet thanked wookie for this post.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
