I need get first value which belong to one fiscal week and the others have zero. I have IF(COUNTIF(B2:B40,B2)>1,IF(COUNTIF(B$2:B2,B2)=1,C2,0),""). But I also want the same in the same cell for another person.
A B C D E An Khaly August Week 32 40 40 40 An Khaly August Week 32 40 0 0 An Khaly August Week 32 40 0 0 An Khaly August Week 32 40 0 0 An Khaly August Week 32 40 0 0 An Khaly August Week 33 40 40 40 An Khaly August Week 34 40 40 40 An Khaly August Week 34 40 0 0 An Khaly August Week 34 40 0 0 Zita Pork August Week 31 40 40 40 Zita Pork August Week 31 40 0 0 Zita Pork August Week 31 40 0 0 Zita Pork August Week 31 40 0 0 Zita Pork August Week 31 40 0 0 Zita Pork August Week 32 20 0 20 Zita Pork August Week 32 20 0 0 Zita Pork August Week 32 20 0 0 Zita Pork August Week 33 20 0 20 Zita Pork August Week 33 20 0 0
My problem is, that my formula works only for one person (column D) but I need to work for all name with the same fiscal week (column E). Can anybody please help? Thx
Aucun commentaire:
Enregistrer un commentaire