Hello,
I am trying to obtain values for the 10 most recent dates in column E (I can't sort by date for other reasons). Dates are in column A, values in column B. However, the index/match formula I used is pulling duplicate values for the same date instead of going to the next instance. For example, I have two values for the same date, however the formula just populates the value from the first instance. Any help would be appreciated! Spreadsheet attached.
=INDEX($B$2:$B$21,MATCH(LARGE($A$2:$A$21,ROWS($E$2:$E2)),$A$2:$A$21,0))
Bookmarks