Dear all
I want to calculate the quartile of the global appreciation score (C2:C48 = column of Table319 which I named "globale") per workshop.
I named A2:A48 = column of Table319 "workshop". Table319 is on the sheet: "Data workshops - Make-over".
For example for the first quartile: {=QUARTILE(IF(workshop=$D5,globale),1)}
The formula gave the correct results for ONLY 2 of the 4 workhshops (see attachment).
Can someone please help me to correct this?
Thank you in advance
J.
I want to calculate the quartile of the global appreciation score (C2:C48 = column of Table319 which I named "globale") per workshop.
I named A2:A48 = column of Table319 "workshop". Table319 is on the sheet: "Data workshops - Make-over".
For example for the first quartile: {=QUARTILE(IF(workshop=$D5,globale),1)}
The formula gave the correct results for ONLY 2 of the 4 workhshops (see attachment).
Can someone please help me to correct this?
Thank you in advance
J.