Visit the Forums
Register Now!

User Login


Forum Topic

excel macro programming

  • Hello, is there a way para i match yung letter ng formula kung nasaang column ka?

    For example:

    Nasa Column A ako pero ang laman ng cell sa column ko is letter B (ex. Column A cell[=B+1]), then pag na-drag ko sya sa right(Column B), mag increment sya ng +1 sa letter (Column B cell[=C+1]).

    Gusto ko sanang mangyari eh kung ano nasaang column ako eh match din yung letter nya dun sa cell ko. (Column A cell[=A+1], Column B cell[=B+1])

    Please help.

    -- edited by jeff_3429 on May 08 2016, 10:56 AM
  • jeff_3429

    Not sure if ganto gusto mo.. if you want to use it in a formula calculation, you have to combine it with the INDIRECT function.
    May better way siguro, yan lang naisip ko on top of my head.

    =SUBSTITUTE(ADDRESS(ROW(),COLUMN(),4,1),ROW(),"")
  • How to reveal texts ng isang cell?

    Parang engraved na white color sya pag naka highlight yung cell. Paano i reveal yung laman nun?

    Thanks in advance.

    -- edited by jeff_3429 on Jun 11 2016, 01:39 AM
  • How to have to texts in the result of your formula? (For example, "P"(for Pesos sign) + the result of a formula of cells so the output of it would be P xx,xxx.xx)

    Thanks in advance ^_^.
  • ^Right Click>Format Cells>Number Tab>Customs>Type = P #,##0.00
  • ^Salamar sir @dodick ^_^.
  • ^
    Parang ang dami mong projects sa Excel. hehe.
  • ^Hindi naman gaano sir @gianpaolo31, hehe. Yung binibigay kasi saming computations eh kulang kulang. Mas maganda kasi pag kumpleto at wala nang problema template. mas maganda kung lahat ng options eh may template na ko. para bato na lang ng bato sa mga leads, hehe... Buti na lang may thread na ganito dito :)
  • mga sir baka po may maktulong saken, parang special type ng filtering ang kailangan




    http://i64.tinypic.com/1177lns.jpg

    -- edited by Kircchoffs on Aug 16 2016, 01:25 PM

    -- edited by Kircchoffs on Aug 16 2016, 01:26 PM

    -- edited by Kircchoffs on Aug 16 2016, 01:28 PM
  • Di masyado kita yung image ahaha.
  • ^ sir edited po ^_^
  • Anong klaseng filter kailangan nyo sir? Anong objective?
  • @Kircchoffs
    Try this formula:

    on E:2
    =IF(C2="x",B2,IF(E1<>FALSE,IF(LEFT(B1,8)=LEFT(B2,8),B2)))

    just take note, ngstart ako sa A ung syo sa B. Do the adjustment after getting the result ung E na ifilter mo... Good luck, hope this help.

    -- edited by dodick on Aug 16 2016, 03:12 PM
  • @Sir dodick
    ok na ok po yung formula nyo sir.thanks po.

    by the way may times din po na yung sub levels di katulad ng upper level, so yung fomula na IF(LEFT(B1,8)=LEFT(B2,8),B2 di pwede.

    @Sir gianpaolo31 ganito po ang exact na gusto kong mangyari


  • @Kircchoffs
    by the way may times din po na yung sub levels di katulad ng upper level, so yung fomula na IF(LEFT(B1,8)=LEFT(B2,8),B2 di pwede.

    if that's the case it should have at least a marker or else your first problem defeat it's purpose.
  • ^ sir dodick mukhang nakuha ko na sa ganitong formula,
    =IF(C2="x",B2,IF(E1<>FALSE,IF(A2=1,FALSE,B2))), salamat sa idea
  • @Kircchoffs
    U'r most welcome at syempre Thanks din sa TS nito...