Hi everyone
I have used the formula =IF(SUM(COUNTIF(D:D,{"*auditory*"})),1,0) to get back a "1" if the word "auditory" appears in column D.
Now, I want to create the same thing, but I want it to return "1" if in column D contains both "auditory" and "5".
I also want in some cases a formula that will return "1" if a specific column contains "audio" and "5" or "audio" and "4" and so on.
Any suggestions?
Thank you!
Can also be: return 1 if the column contains "A_any number of other characters_B" (a phrase containing A, then more characters, then B)
Thanks!
Something like this?
=IF(OR(ISTEXT(D:D),ISNUMBER(D:D)),1,0)
Hmm... Not sure what that does.
That is Array Formula
Hit CTRL-SHIFT-ENTER Button together
Azumi
Still not clear what exactly I should do.
Anyone has a formula that can do that?
Thanks!
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks