jeudi 2 novembre 2017

Excel - Multiple Conditions

I am trying to get a column with the MINIMUM and the MAXIMUM monetary order values (G.T. Base) per person, split into the first order and the last order of the person itself.

I used MINIFS and MAXIFS to calculate the FIRST ORDER and LAST ORDER for each person but now I am stuck on how to add the monetary value for the first and the last order for each person.

Can you please help?

Thanks!

enter image description here

Aucun commentaire:

Enregistrer un commentaire