+ Reply to Thread
Results 1 to 5 of 5

Need help creating formula in Excel 2007

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    USA, Indiana
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Need help creating formula in Excel 2007

    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

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Need help creating formula in Excel 2007

    What are you asking?

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Need help creating formula in Excel 2007

    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
    Audere est facere

  4. #4
    Registered User
    Join Date
    03-25-2012
    Location
    USA, Indiana
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Need help creating formula in Excel 2007

    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.

  5. #5
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Need help creating formula in Excel 2007

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1