L
Ltat42a
I'm using the countif formula to look up certain keywords in a
column(=COUNTIF(Sheet1!G1:G1170,"George"). In my column, there will be
different entries other than just "George". There may be George Smith,
George Jones, George Thompson, etc...etc...
Is there a better formula that will return a result for all "george's".
Right now, it doesn't return anything because of the various George's.
Thanx.
column(=COUNTIF(Sheet1!G1:G1170,"George"). In my column, there will be
different entries other than just "George". There may be George Smith,
George Jones, George Thompson, etc...etc...
Is there a better formula that will return a result for all "george's".
Right now, it doesn't return anything because of the various George's.
Thanx.