Forum Discussion
concatenate and if statements
have if statement for a current project:
=Ij($d$42="Raymond",countif($b$57:$n$57,WkrTable($d$20),0)
wich can have far too many variants (up to 50). Far too cumbersome, far too complex. Have tri...
Thank you so much for your help in the struggle to do the leadership counting. Everything works across the whole month. Now on to the next task. I've attached the updated file for you to look at. At the bottom of the second page of LdrSch you'll see a section called conflict analysis which looks for a situation in which a person might have been scheduled to do two tasks at the same time. In the row called "afterglow" vs Ministry" I've put this formula
=if(d$45=(match(d$42,MinistryTeam!$a$2:$e$2,0)),"conflict",0)
which should return "conflict" because Mike B. is both on afterglow and on the ministry team of Raymond. Instead it returns 0. Can you tell me where I went wrong?
Hi Steve,
Okay, will check bit later