Need help creating formula in Excel 2007

**tshirtgrg** · 03-25-2012, 02:12 PM

If I type text U128 in A1 and
I type text 44 in A2 and
I Paste this long number in A3 01956843571651243202001200121461832645872305
and
position 1 thru 2 is 01
and position 17 thru 20 is 3202
and position 27 thru 28 is 12

Then it's a match if not it's false

**Dennis7849** · 03-25-2012, 02:19 PM

What are you asking?

**daddylonglegs** · 03-25-2012, 02:39 PM

Not sure where A1 and A2 come into it but to check A3 for those conditions you could use this formula

=COUNTIF(A3,"01"&REPT("?",14)&"3202"&REPT("?",6)&"12"&"*")>0

You can replace "01", "3202" and "12" with cell references if you want

**tshirtgrg** · 03-25-2012, 07:17 PM

Thanks,
This is working. Could you please explain the ("?",14) and ("?",6)
I don't understand how that counts what position the number is in.
Please explain if you can so I can further experiment with this.

**Paul** · 03-25-2012, 08:29 PM

Hi tshirtgrg,

I'm glad you received assistance and that your issue is resolved. However, in the future please create thread titles that are descriptive of your issue, per the forum rules. There is a link in my signature to those rules, which you should review prior to posting again.

Thank you.