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.
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.
Help me Please
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.
like tthis ?
"*#50,*#200,*#400"
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
"*#" 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
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?
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.
the MOB is right but the DEMOB i not
Sir here what i dis. can u gelp me
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.
sir i use this but it still ing No. 38 Only
Please Login or Register to view this content.
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
ps why go to all the effort to get ctrRate but not use it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks