+ Reply to Thread
Results 1 to 3 of 3

trimmean last 6 of variable (by column) entries

Hybrid View

  1. #1
    Registered User
    Join Date
    05-14-2005
    Posts
    5

    trimmean last 6 of variable (by column) entries

    In column E, I want the median of the last 6 entries in columns K to EJ, where EJ is the oldest entry, and I want to median the most recent 6, that is, the last 6 entries counting inward from column K toward EJ.

    There will be blanks, and each row will have different columns filled, most columns empty, so I want to median the last 6 entered numbers.

    Thanks very much in advance.

    Oh, and ignore the title, I meant to write "median of last 6," obv.
    Last edited by pay2play; 12-12-2008 at 06:02 AM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,700
    Try this formula for row 2

    =MEDIAN(K2:INDEX(K2:EJ2,SMALL(IF(K2:EJ2<>"",COLUMN(K2:EJ2)-COLUMN(K2)+1),MIN(6,COUNT(K2:EJ2)))))

    confirmed with CTRL+SHIFT+ENTER

    That gives the median of the 6 most recent values....if there are less than 6 values it gives the median of them all......

  3. #3
    Registered User
    Join Date
    05-14-2005
    Posts
    5
    TY, longlegs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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