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
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.