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
|