match or vlookup substring in a cell
match or vlookup substring in a cell
Hi
Support few cells has a values like
MOC-Apple-iPhone-SE-1
MOC-Apple-iPhone-SE-2
MOC-Apple-iPhone-SE-3
MOC-Apple-iPhone-SE-4
I want to count the no cells which contains
MOC-Apple-iPhone-SE-
how do i do that
at the end result should be 4