D
Darby
I am trying to find a text string within a text field column in a large
spreadsheet.
I've discovered that =COUNTIF(A1,"*abc*") does not work if the starting
position of the text is >300
=SEARCH("abc",A1) and =FIND("abc",A1) both seem to work fine.
The spreadsheet is big and slow so I'd like to pick the most efficient
choice, but am also wondering what the difference between the 2 options are.
Thanks
spreadsheet.
I've discovered that =COUNTIF(A1,"*abc*") does not work if the starting
position of the text is >300
=SEARCH("abc",A1) and =FIND("abc",A1) both seem to work fine.
The spreadsheet is big and slow so I'd like to pick the most efficient
choice, but am also wondering what the difference between the 2 options are.
Thanks