+ Reply to Thread
Results 1 to 14 of 14

how to use "LIKE function" ?

  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    how to use "LIKE function" ?

    how to use "LIKE function" ? i want to add my program read this. 100, 200 , 400 , 600 , 1000. THis is the program. and i upload my workbook. Help me please thanks Godbless.



    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    Help me Please

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: how to use "LIKE function" ?

    use # to represent numbers

    Please Login or Register  to view this content.
    Last edited by humdingaling; 10-15-2015 at 01:51 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    like tthis ?


    "*#50,*#200,*#400"

  5. #5
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    i do it sir. i ask again sir. hows the MOB and DEMOB ? i want to place it in the name of the Contructors but when i run my program they scramble the MOB and DEMOB Help me Please

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: how to use "LIKE function" ?

    "*#" covers everything that is a number regardless of any how digits it is

    "*#50"
    would look for something that ends has numbers and ends with 50

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: how to use "LIKE function" ?

    not quite sure what you are actually wanting to do
    did you run my code?
    it gives 144 which is the number of lines which has numbers in that row?

    what were you expecting as output?

  8. #8
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    yes sir. is this the code ?? the out out is all the 100 to 100 type paste the MOB and DEMOB with in front of ther COntractors





    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    the MOB is right but the DEMOB i not

  10. #10
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    Sir here what i dis. can u gelp me
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    Sorry for the wrong message. the Output i want is the 100 to 1000 type are have a MOD and DEMOB like for the type "100" is 1 to 19. the 1 to 19 Have the Output of the MOB and DEMOB.

    The MOB will get in 115 to 133.
    The DEMOB will get in 134 to 152.

  12. #12
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: how to use "LIKE function" ?

    sir i use this but it still ing No. 38 Only

    Please Login or Register  to view this content.

  13. #13
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: how to use "LIKE function" ?

    what you are asking for is nothing to do with your original question

    the more i read your queries the more i am getting confused to what you are actually asking for

    please explain clearly what the code is meant to do and what it is not doing

  14. #14
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: how to use "LIKE function" ?

    ps why go to all the effort to get ctrRate but not use it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use InStr function to search for a text that starts with "CTF" and ends with "."?
    By yoursamrit2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2014, 06:52 PM
  2. Replies: 1
    Last Post: 01-15-2014, 08:53 AM
  3. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. [SOLVED] Variable "sheet-name" and "range-name" wanted in INDEX/MATCH-function
    By Fiebuls in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2012, 04:09 PM
  6. [SOLVED] Please add a "sheet" function like "row" and "column" functions
    By Spreadsheet Monkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2005, 12:15 PM
  7. [SOLVED] Replace "insert function" with "edit formula" button in fourmula b
    By 13brian in forum Excel General
    Replies: 0
    Last Post: 08-24-2005, 04:05 PM

Tags for this Thread

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