Results 1 to 3 of 3

Mode on multiple groups

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013, 2016
    Posts
    42

    Mode on multiple groups

    Dear Experts,

    Is it possible to calculate the mode for multiple groups.

    In the document, in kolom H i have all the month numbers lined up. In kolom I, I want to see the mode of Kolom E per month.
    This means that I want to know per month, which # days in stock is the most occuring.

    I tried to explain this as good as possible. Please tell me if you don't understand my question.

    Many thanks.

    --- EDIT---

    For some reason I can't seem to upload the attachment:

    Upload Errors
    Excel forum Mode.xlsx - Upload of file failed.
    Last edited by gromtouwe; 09-13-2017 at 04:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 03:05 PM
  2. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
    By || cypher || in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1