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, Aug 5, 2010.

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. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,559
    First Name:
    Hans
    You sohould take a look at the different types of COUNT functions, COUNTIF, COUNTA etc.
    You can find most of these in the Help function

    A link I use quite often http://www.cpearson.com/Excel/Topic.aspx
     
  3. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Do you know the range of numbers that will be in those cells - that is, will they all be positive but under 10, under 100, negative and positive, etc.?
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,559
    First Name:
    Hans
    I imagine you could choose the rank function and apply it to that range?
     
  5. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
  6. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    This might give you a few ideas...sorry, I had to zip it. It shouldn't be that big, but the site refused it as an Excel file.
     

    Attached Files:

  7. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,559
    First Name:
    Hans
    Okay, I'm off to bed (11 PM+), I'm bushed.
     
  8. Sponsor

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/940788

  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