View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Is there anything like the Access "LIKE" function in Excel?

pa1971 wrote...
I would like to identify only the values in a spreadsheet with "CU"
included in them. That "CU" could be at the beginning, end or middle
of the values in the column. In access I could use the LIKE feature.
Is there anything similar in Excel to identify them?


Count them? Use

=COUNTIF(YourRangeAddressHere,"*CU*")

Find the index of the first one in a 1D range? Use

=MATCH("*CU*",YourRangeAddressHere,0)

Find the index of the n_th (n 1) one in a 1D range? Use the array
formula

=SMALL(IF(ISNUMBER(SEARCH("*CU*",YourRangeAddressH ere)),
ROW(YourRangeAddressHere)-MIN(ROW(YourRangeAddressHere))+1),n)