View original (French)

AGGREGATE formula with conditions

Solved
Bourrique66 Posted messages 166 Status Member -  
Bourrique66 Posted messages 166 Status Member -
Hello,
I would like to know if it's possible to set conditions in the AGREGAT formula. In sheet 2 of the attached file, in columns K, L, and M I use the AGREGAT function, but I would like to only get the dates of 2018 in column K, the dates of 2019 in column L, and finally the dates of 2020 in column M. How can I do that? Thank you for your responses.

https://www.cjoint.com/c/HDBjKesFRd4

2 answers

  2.
    Bourrique66 Posted messages 166 Status Member 2
     
    Hello,
    I just tested the matrix formula in my project and it's perfect. The results are here as usual on this forum, I think I am at the end of my project thanks to you. Thanks again to everyone for your invaluable help. The issue is resolved.
    0