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!
Aucun commentaire:
Enregistrer un commentaire