Feb 19 2019 04:10 PM - edited Feb 20 2019 12:51 AM
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 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!
Kind regards!
Feb 20 2019 01:25 AM
Hi,
This should solve your problem, =IF(IFERROR(FIND(B$1,$A$3,1),0),1,0) see attached
Feb 20 2019 02:05 AM
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?
Kind regards.
Feb 20 2019 06:44 AM
Feb 25 2019 05:13 AM
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!