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