max(filter()) giving an error for date range in sheets

Viewed 86
1 Answers

use in C4:

=INDEX(SORTN(SORT({data!B2:B, data!A2:A}, data!F2:F, 0), 9^9, 2, 2, 1),,1)

enter image description here

Related