LinkBack URL
About LinkBacks
I need help with creating a formula that will return a 1 if "(A)" are in the string.
The string will be something like this: San Diego (A)
There will be a list of 30 names. Some will have the (A) while the rest will have (N).
Thanks for any help.
I need help with creating a formula that will return a 1 if "(A)" are in the string.
The string will be something like this: San Diego (A)
There will be a list of 30 names. Some will have the (A) while the rest will have (N).
Thanks for any help.
How about
=COUNTIF(A2:A13,"*(A)*")
=if(iserror(search("(a)",a2,1)),"",1)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks Etaf, that's the winner.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks