View Single Post
 
Old 05-11-2015, 09:59 AM
beginner beginner is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Default

Quote:
Originally Posted by derohanes View Post
I want to look for "EP" instead of "EPA".
Try in B2
Code:
=COUNTIF(Sheet1!$B$2:$C$6;"*"&A2&"*")
Reply With Quote