mercredi 14 décembre 2016

How can I find the top 5 values from a range, only from a specific month?

=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