+ Reply to Thread
Results 1 to 4 of 4

Modal average for every 10 cells?

  1. #1
    Registered User
    Join Date
    03-13-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Modal average for every 10 cells?

    Hello,

    I would like to take the modal average of every 10 cells (i.e. D2:D11, then D12:D21, D22:D31 etc.) over 50000 rows of data. Does anybody know how I can do this?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Modal average for every 10 cells?

    One possibility:
    =IFERROR(MEDIAN(INDEX($D$2:$D$101,1+10*(ROWS(G$2:G2)-1),):INDEX($D$2:$D$101,10+10*(ROWS(G$2:G2)-1),)),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    03-13-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Re: Modal average for every 10 cells?

    Thank you very much, that seems to have solved the issue perfectly.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Modal average for every 10 cells?

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Taking the average of multiple groups of cells with ability to extend range of average
    By 2597Gar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2019, 11:07 AM
  2. Non modal form closes with modal form when it is closed
    By ryan.wherry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2015, 12:45 PM
  3. Replies: 14
    Last Post: 06-14-2013, 09:00 PM
  4. The rank of average ranks excluding empty cells but including their average.
    By Terminal45 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2012, 03:44 AM
  5. [SOLVED] Forms that are modal in 97 are not modal in 2003
    By Old Car in forum Excel General
    Replies: 2
    Last Post: 04-27-2005, 04:06 AM
  6. Forms that are modal in 97 are not modal in 2003
    By Old Car in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2005, 04:06 AM
  7. Modal Forms
    By MJRay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2005, 02:06 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