|
countif wildcards?
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 |
countif wildcards?
Try
=COUNTIF(A1:A10,"*George*") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ltat42a" wrote in message ... 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 |
countif wildcards?
=COUNTIF(G1:G1170,"*george*")
Bob Umlas Excel MVP "Ltat42a" wrote in message ... 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 |
countif wildcards?
Chip Pearson Wrote: Try =COUNTIF(A1:A10,"*George*") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ltat42a" wrote in message ... 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 Thanx Chip....that works great! JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=494440 |
| All times are GMT +1. The time now is 09:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com