jeudi 31 mai 2018

SUMIFS combine with LARGE

Is there a way to combine "LARGE" with "IF"?

My Large formula is working, but if I want to Combine it with "IF", I don't know, how to solve it. The Problem is that I have named an Area in the data set with "Area1" and different names in it. I want for "Name1", which is in the "Area1" several times, the highest value he can find in another named area,"Area2".

Hope you understand my Problem and can help me out :)

Aucun commentaire:

Enregistrer un commentaire