View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Need help finding a substring in a array of strings.

Hi,

Am Fri, 16 Nov 2012 19:13:38 +0000 schrieb hvcrios:

----A------------------B----------------------C
1 1234-------------FUNCTION-----------5678_hh_buzzzz
2 5678-------------FUNCTION-----------9866_hh_buzzzz
3 9866-------------FUNCTION-----------1237_hh_buzzzz
4 5248-------------FUNCTION-----------9975_hh_buzzzz
5 1237-------------FUNCTION-----------0832_hh_buzzzz


try:
=COUNTIF($C$1:$C$388,A1&"*")0


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2