=IF(MONTH(D2:D100)=7,LARGE($F$2:$F$100,K19),0)
I am trying to find the top 5 values from the range F2:F100, but i am only interested in the values from a sale during the month of July. The range D2:D100 consists of dates ranging from July to December. I tried to use the above function but it returned a value of "0."
To set the formula I created a helper column with the numbers 1,2,3,4,5 in cells K19:K23.
Aucun commentaire:
Enregistrer un commentaire