Searching cells for a range of values

  • Thread starter Thread starter Graham Worsley
  • Start date Start date
G

Graham Worsley

Hi,
I have a cell that contains a number of values e.g. UC123, UC124, UC125,
UC126. These occur in any order. I want to filter only those that contain
UC123 or UC125 (or both). Is there an Excel formula that does this?
 
Hi
use the following formula in an adjacent cell
=IF(SUM(COUNTIF(A1,{"*UC123*","*UC125*"})),"X","")
and fílter all 'X' rows
 
Hi,
Thanks a lot, that has worked fine!


Frank Kabel said:
Hi
use the following formula in an adjacent cell
=IF(SUM(COUNTIF(A1,{"*UC123*","*UC125*"})),"X","")
and fílter all 'X' rows
Click to expand...
 
Back
Top