Finding exact string using a formula (excel)

-

i'm trying use find statement find multiple strings in context of larger formula. original formula i'm basing off of follows:

=if(isnumber(find("inc",a1))," ","y")

obviously, yields y if finds whatever text in " ". however, have many strings i'd check , need exact; ie when search inc , inc, not want inc counted. so, tried following formulas.

=if(isnumber(find(or("inc",inc"),a1))," ","y")

=if(sum(countif(a1,"* inc*","* inc*}))," ","y")

the second 1 works best, counts "inc" match. suggestions?


hi,

i recommend asking question in excel forum:

http://social.technet.microsoft.com/forums/en-us/home?forum=excel&filter=alltypes&sort=lastpostdesc

there's excel forum on over msdn side well, focuses more on vba:

http://social.msdn.microsoft.com/forums/en-us/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

this powershell forum.

don't retire technet! - (don't give yet - 12,950+ strong , growing)



Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

Cannot access Anywhere Access using domain name?

-
after installing anywhere access in windows server 2012 essentials r2, cannot use anywhere access using setup domain name in wizard such remote.mydomain.com? if enter public ip address, example, 72.2.34.5 works. before set anywhere access, created a record pointing public address...pinged , worked...so not sure doing wrong?  is wizard supposed create record etc , make remote.mydomain.com work? if enter public ip address while on lan, takes me router webpage.  shouldn't work on lan if accessed via public ip? thank you, tim. the wizard can configure remote.microsoft_names.com  remote.remotewebaccess.com but cannot configure domains purchased outside wizard.  depends on how domain configured if wildcard.yourdomain.com should work  if try ping remote.your_domain.com afar , not give proper  public ip, need add record mariette said. much have record domain.com www.domain.com , if have website somewhere else www.domain.com , need re...
Read more

server manager error: ADAM.events.xml could not be enumerated.

-
firewall off isnt it. rerun ldap wizard:?  why?  will screw exchange server running on machine?  ldap wizard asks questions don't understand. please dont send generic links to: http://social.technet.microsoft.com/wiki/contents/articles/13444.windows-server-2012-server-manager-troubleshooting-guide-part-ii-troubleshoot-manageability-status-errors-in-server-manager.aspx thanks, john hi john, >> ok. server manager app. these questions refer this. nothing else 2.  do need create app dir or not?  this server manager, shouldnt done? (why did break in first place?) how check if app dir exists server manager or not. 3.  if "lightweight" implementation of anything, sure hate see "heavyweight" version. the waring events can't enumerated. , cause not completing configuration of ad lds. ad lds not related server manager. used provide flexible support directory-enabled applications. if not implementing such application...
Read more

send messages to users

-
i have domain server windows 2000 sp4. my clients using win xp , win 98. when send messages computer management-shared folders-rightclick-all task-send message connected users, message received clients using winxp but not in  win 98 .how send them without winpopup  , net meeting. this forum windows server 2008.   check messenger service running on win98-clients. (haven't seen win 98 in while might not available...) Windows Server  >  Directory Services
Read more