Forum Discussion
Countifs / create columns for each attribute with datatype 1/0
Hey guys, I am not sure if the subject ist understandable... I hope you can help with my topic. I never heard from COUNTIFs before, but heard that my "problem" can be solved with this excel functio...
Hi,
This should solve your problem, =IF(IFERROR(FIND(B$1,$A$3,1),0),1,0) see attached
If you changed the formula to =IF(IFERROR(FIND("/" & B$1,$A$3,1),0),1,0), it wouldn't work for the first entry (no forward slash) but would for everything else.
Thank you very much for your help again.
I just want to let you know that following (german) code worked for me:
=ISTZAHL(FINDEN("#"&M$1&"#";"#"&WECHSELN($G20;" / ";"#")&"#"))*1
Cheers!
