Hi,
I want to show a maximum value of an array (of dates) based on a combination of two criteria (a kind of 'MAXIFS' function).
My data is a bit like this ...
<tbody>
A
B
C
1
Date
Criteria 1 met?
Criteria 2 met?
2
01/03/2015
y
y
3
15/06/2015
n
y
4
21/06/2015
y
y
5
08/01/2016
n
y
6...