1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

excel 2003 formulas and functions

Discussion in 'Business Applications' started by cpcarter, Jan 30, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. cpcarter

    cpcarter Thread Starter

    Joined:
    Nov 27, 2008
    Messages:
    69
    I want to know fi there is a formula or function which can determine the most number of times a value appears within a range of cells. For example, cells a1 thru to g10 contain a variety of numerical values, some more than others. Now I want excel to tell me in cell a12 the number that appears most within the range a1 thru to g10. I also want excel to tell me in cell b12, the second most common number that appeared within the range. And so on...

    Is there such a formula?

    I look forward to your responses.:cool:
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,965
    First Name:
    Wayne
    =mode(range)
    should give you that info

    so in A12 type
    =mode( a1:g10)
     
  3. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,559
    First Name:
    Hans
    The formula was a new one to me but if you use it and there are two series of numbers that occur equally then only the first occurrence is shown
    Code:
    [B]3[/B] < mode	[COLOR="Red"]3	3	3	3[/COLOR]	6	6	6	6	2	1	7	9	2	1	0	1	1
    [B]6[/B] < mode	[COLOR="red"]6	6	6	6[/COLOR]	3	3	3	3	2	1	7	9	2	1	0	1	1
    
    Just curious how it worked anyway
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,965
    First Name:
    Wayne
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/977921

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice