Daily Dose of Excel » Blog Archive » Simulating a LIKE function
Excel doesn’t have a LIKE function, but you can use the COUNTIF function to pretend that it does. If LIKE existed, you might test the pattern of a cell like this ... Hi, I’d like to use a cell reference instead of a defined string but can’t seem to get th...