Shaun0269 September 12, 2011 at 11:29:52 Specs: Windows 2007, Pentium 4 2GHz / 4 gigs
I have 2 columns I need to confirm contains the same document number the first column has 5999 the second column has it in an alpha numeric sequence 003D-999-02-C111. The document number I need to confirm is the same is the "999".
The 4 characters will be the same length 95% of the time the 5% they will be 3 characters. The 16 characters will be the same length 75% of the time with 25% of the time the characters being 22 characters with them always ending in -V.
The alpha numeric sequence will always show the target numbers begging with the sixth character and yes they will always be the three digits.
Thanks Mike, it works however I found some of the data in the column A with the 4 digit number have a description like "5999 - Site Preparation" the rows with the description it's giving me a no match even though the numbers match.
How can I update the formula to get the formula correct this. Here is what it looks like.
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.