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 revel texts ng isang cell?

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

    Thanks in advance.