• 549K Members
• 4,279 Online
• 658K Conversations

Highlighted
New Contributor

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

I try it to describe with the attached screenshots.

I want "transfer" this list

into such one:

Is this possible?

Kind regards!

4 Replies
Highlighted

# Re: Countifs / create columns for each attribute with datatype 1/0

Hi,

This should solve your problem, =IF(IFERROR(FIND(B\$1,\$A\$3,1),0),1,0)  see attached

Highlighted

# Re: Countifs / create columns for each attribute with datatype 1/0

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.

Highlighted

# Re: Countifs / create columns for each attribute with datatype 1/0

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.

# Re: Countifs / create columns for each attribute with datatype 1/0

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!

Related Conversations
Multiple Selections Drop Down List (used a VBA code) & CountIfs
Teeah in Excel on
0 Replies
Apply locked for editing
martinarenkacouk in Excel on
2 Replies
COUNTIF not working
sme527 in Excel on
10 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Totaling using two sets of data
dazedandconfused in Excel on
2 Replies