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)
|