*** The TPC Android application IS NOT OFFICIAL. Use it at your own risk! ***
Using the app GIVES THE DEVELOPER ACCESS TO YOUR LOGIN DETAILS.

Forum Topic

excel macro programming

  • from sir olayskie's formula: just added Find function. let us know if its working...

    =IF(LEFT(A1,3)="110",MID(A1,5,FIND("-",A1,5)-5),"")

    Kircchoffs, try mo rin pglaruan ang mga string functions. it will help u a lot in simple formulas like this one.
  • @olayskie and dodick

    thanks mga sir both working po sila ^_^
  • meron po bang parang crash course dito sa philippines about sa macro programming?
  • mga sir need your help po ulit para sa new project ko


  • =if(D2 = "x", E2, D2* E2)?
  • =if(D2 = "x", E2, D2* E2)?


    di po working sir. 3 po kasi yung variable, LEVEL, ITEM at QTY.

    anyway may tumulong na rin po saken sa ibang thread. ^_^

    =IF(AND(B2=1,D2="X")=TRUE,E2,IF(INDIRECT("D"&ROW()-1)="X",E2*INDIRECT("E"&ROW()-1),IF(INDIRECT("D"&ROW()-2)="X",E2*INDIRECT("E"&ROW()-2),IF(INDIRECT("D"&ROW()-3)="X",E2*INDIRECT("E"&ROW()-3),IF(INDIRECT("D"&ROW()-4)="X",E2*INDIRECT("E"&ROW()-4),IF(INDIRECT("D"&ROW()-5)="X",E2*INDIRECT("E"&ROW()-5),"array"))))))
  • Tanong: Meron akong date column with the following format 02-05-2017 8:54:00 AM I need to add another column that should have either a Y or N. The rule is if yung date column is equivalent to yesterdays date then dapat Y if not then N. Salamat in advance.
  • @Crash,
    easiest way is to extract the day with this function @DAY(date) then create an IF statement as shown below:
    A1
    2/5/17 8:54 AM
    B1
    2/4/17 12:00 AM (for comparison)
    C1
    =IF(DAY(A1)-1=DAY(B1),"Y","N")

    Just note that this formula assume the comparison as same month and year. Hope it helps...
  • =if(D2 = "x", E2, D2* E2)?


    di po working sir. 3 po kasi yung variable, LEVEL, ITEM at QTY.


    Should be working since the 2 variables are just the same.

    B and D columns can be used since X is always equal to 1.
  • Kaya lang hindi nag work kasi wala pang value yung blanks mo sa column D.
  • any tips on "where to start" for VBA para sa beginners?
  • Should be working since the 2 variables are just the same.

    B and D columns can be used since X is always equal to 1.


    Di talaga magwowork yun Sir, kasi nakabase yung first factor sa prior Level 1 niya (E2, E8, E14, and so on). And mali rin po yung D2*E2 kasi ang value ng D2 ay "x" or blank lang.

    If nagwowok na yung may array and INDIRECT, thats' good. :) Medyo nakukumplikaduhan lang ako, baka may mas simpleng way. :)

    Hello pala! ngayon ko lang nakita na may ganitong thread. :)
  • Tanong: Meron akong date column with the following format 02-05-2017 8:54:00 AM I need to add another column that should have either a Y or N. The rule is if yung date column is equivalent to yesterdays date then dapat Y if not then N. Salamat in advance.


    =IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-1),"Y","N")

    A1 sir yung column ng dates niyo. But note sir na yung Today() ay nagbabago bago bawat araw. :) You can replace today() by a cell kung saan nakalagay yung reference date. :)
  • any tips on "where to start" for VBA para sa beginners?

    start by using macro, record ka ng mga simple tasks (e.g. Find&Replace, Text to Columns, select ranges and so on..). then from there, edit mo ung macro at dun ka mgstart pumickup ng mga coding and eventually you are already learning vba... maraming approach na pwede, mas maige prin yun learn by sample/application. remember nandyan naman palagi si F1 and/or Google... good luck.
  • Di talaga magwowork yun Sir, kasi nakabase yung first factor sa prior Level 1 niya (E2, E8, E14, and so on). And mali rin po yung D2*E2 kasi ang value ng D2 ay "x" or blank lang.


    No...try the formula first... or pwede dagdagan pa ng isang condition na pag blank eh kunin niya yung last column value

    tignan mong maigi... 2 levels lang meron

    1&2 and X = 1 and blank = 2

    so if we consider the blank space sa column D

    Per se ganito ang pinaka simple


    Formula nested if's

    =IF(C3="x",D3,IF(C3="",D3,C3*D3))

    -- edited by emcel on Apr 26 2017, 08:19 PM

    -- edited by emcel on Apr 26 2017, 08:22 PM
  • Mga Sir pa help naman po about excel. Kanina pa ko nag search sa google pero wala ako makita exact scenario sa problem ko.

    Gusto ko sana i match ung first 4 characters sa column A sa column B

    then ung match pupunta sa column C, yung di match ay iwan lang.

    Bale yung column A ang pipiliin at yung column B ang pagpipipilian

    let say 100 items sa column A, then 500 items sa column B

    TIA