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 function..
I try it to describe with the attached screenshots.
I want "transfer" this list
into such one:
Is this possible?
Thank you very much for your help in advance!
This should solve your problem, =IF(IFERROR(FIND(B$1,$A$3,1),0),1,0) see attached
Wow, great! Thank you very much! Will try it out later.
But could it be that when I have e.g
Memberlist: Deep-House; House; Techno;
that this formula can not "spilt" the two genres in its own cells with 1/0, because the formula can not distinguish the word House? (Deep-House; House;)
You know what I mean?
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