I have a sheet where entries from users are listed in this format:
A16:A = NAME
E16:E = DATE
AB16:AB = EFFICIENCY
Above these cells and on the same sheet, I am setting up cells to collect this data using formulas so that the average efficiency on all identical Nth most recent dates for a specified name can be seen. This is fairly straightforward for the most recent date:
MOST RECENT ENTRIES: =AVERAGEIFS(AB16:AB,A16:A,"FREDDY",E16:E,MAX(E16:E))
My issue is how do I accomplish this for the remaining 4 requirements:
2ND MOST RECENT ENTRIES
3RD MOST RECENT ENTRIES
4TH MOST RECENT ENTRIES
5TH MOST RECENT ENTRIES
Any help would be greatly appreciated, thank you!
Bookmarks