Trying to find out the Largest value in column V when Year in A column matches with 2021 and Month matches with March (3).
Formula tried:
=ArrayFormula(large(If(AND(YEAR(A:A)="2021",MONTH(A:A)=3),V:V),1))
Above one giving me error :
LARGE has no valid input data.
There are entries which matches with year=2021 and month=3. can you guide me why it is giving me above error