How to Search down a column fo a specific number of digits
 

Good Morning,

I am wondering what formula or how i could go about searching for a specific number of digits in a cell down a column.

I Have For example:

4213211_ghdjk_null_2_
4213212_ghdjk_null_7_

and I want to use the isnumber(match( formula in conjnuction so i can compare the first 7 digits in column B data with that of the one listed above which is in column A.

So overall i want to search within column "A" using the data in column "B" and return a "True" if the data is found in column "A" and "False" if "B" column data is not found in "A". But i must limit the isnumber(Match( formula to 7 digits (or values, not well educated with excel) otherwise it will return with a false due to the "_ghdjk_null_2_" string at the end.

A B c
1 4213211_ghdjk_null_2_ 4213212 True
2 4213212_ghdjk_null_7_ 4213211 True


Simply doing a search will not suffice, too much data.
could be explained in a much simpler fashion, but my lack of experience with excel makes it difficult.

Thank You

How to Search down a column fo a specific number of digits
 

Hi,

Am Wed, 3 Sep 2014 16:51:56 +0100 schrieb SVRider:

A B c
1 4213211_ghdjk_null_2_ 4213212 True
2 4213212_ghdjk_null_7_ 4213211 True

=COUNTIF($A$1:$A$100,B1&"*") will give you the number of matches
=IF(COUNTIF($A$1:$A$100,B1&"*")0,"True","") will give you True if the
number matches


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional