multiple mode values in excel

Posted on 2012-09-14
Last Modified: 2012-10-05
Suppose I have these 3 series of numbers.

Which number would the Excel choose as the mode and why?
How can I replicate this methodology in 3.5 with VB 2008?
Question by:AlHal2
    LVL 50

    Expert Comment

    by:barry houdini
    If you use MODE (or MODE.SNGL in Excel 2010) worksheet function it wouldn't choose any of those - MODE gives you #N/A if there are no duplicate numbers. If 2 or more numbers have the same number of instances it just picks the first instance in the range so if you have


    Excel picks 123

    regards, barry

    Author Comment

    Sorry I didn't make clear.  In each row the numbers are separate.

    1,5,4,6,2,2,1 Excel mode is 1
    1,2,1,3,2,3   Excel Mode is 1
    3,2,3,1,2,1   Excel Mode is 3
    LVL 17

    Accepted Solution

    that would be 1

    barryhoudini already gave the explanation why

    Author Comment

    What about the second part of my question?  Suppose I have one of the above series in a 1D array.  How do I get the same mode as Excel using vb 2008 in 3.5?

    Author Comment

    I've requested that this question be closed as follows:

    Accepted answer: 0 points for AlHal2's comment #a38398416

    for the following reason:

    Partially answered.

    Author Closing Comment

    Partially answered

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now