Home > Software engineering >  Google Sheet LARGE formula error "LARGE has no valid input data"
Google Sheet LARGE formula error "LARGE has no valid input data"

Time:11-10

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

enter image description here

  • Related