EXCEL FORMULA

Copper Contributor

Hello team,

 

I needed a help on the attached file if possible. 

Concerned tab : ANALYSE

When A3 and A6 are filled in, the data B2:H2 are filled in automatically taking into account the data available in tab "DEMANDE ADMIN"

For example, if I put "AOUT" (A3) and VIOLETTEKAETIA (A6), I should be getting the number of EE, ER, DEPART PLANIFIE, RETARD PLANIFIE and PERMISSION PLANIFIE for the agent in that particular month and tab "DEMANDE ADMIN" and cell J:J must be in "OK"

 

Any help would be much appreciated. Thank you.

FYI, the file is in French

 

Reg,

Krishna 

0 Replies