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

Answer 1 / 2
DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
 
Re
I changed your agregat()

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

Best regards
0
Answer 2 / 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