• 506K Members
• 6,418 Online
• 602K 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

# 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
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Discussion - Updating our interface with Fluent touches
Elliot Kirk in Discussions on
102 Replies