• 515K Members
• 4,801 Online
• 612K Conversations

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

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

# 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
Last Value Column from Another Column in Same List
Yepitsme in SharePoint on
6 Replies
Bitlocker keys not visible in Active Directory
Anez1987 in Windows 10 management on
1 Replies