Is there an easy way to have an array formula that will display the top10 values for a certain date period? Note: this period must be variable.
The static way works of course: =SMALL(C1855:C1977,ROW()-(ROW($J$1)-1)) but I need the possibility to change the date range (C1855:C1977) based on other input, secondly, my date range can vary, values are not necessary adjacent. Can this be done with a formula? Writing a macro to calculate the new array is possible, but it's something I'd like to avoid in this case.
Thanks
Bookmarks