Try
=COUNTIF(A1:A10,"*George*")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Ltat42a" <
[email protected]>
wrote in message
news:
[email protected]...
>
> 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.
>
>
> --
> Ltat42a
> ------------------------------------------------------------------------
> Ltat42a's Profile:
> http://www.excelforum.com/member.php...o&userid=24735
> View this thread:
> http://www.excelforum.com/showthread...hreadid=494440
>
Bookmarks