walah, lupa belum set absolute reference nya =substitute( address( 1, column()* ,**4*),1,"")
Wassalam, Kid. 2014/1/25 Mr. Kid <[email protected]> > eh kebalik > =substitute( address( 1, column() ),1,"") > > > 2014/1/25 Mr. Kid <[email protected]> > > oh mau pakai formula untuk dapatkan kolom Excel ya, >> >> Kira-kira begini : >> =substitute( address( row(), 1 ),1,"") >> *** akan terasa manfaatnya kalau sudah sampai kolom AA atau AAA >> >> Wassalam, >> Kid. >> >> >> >> On Sat, Jan 25, 2014 at 9:10 AM, Bagus <[email protected]> wrote: >> >>> >>> >>> Coba begini: >>> >>> =MID(ADDRESS(ROW(),COLUMN()),2,1) >>> >>> >>> >>> Wassalam >>> >>> ~ Bagus ~ >>> >>> >>> >>> ----- Original Message ----- >>> *From:* Hirmanto <[email protected]> >>> *To:* [email protected] >>> *Sent:* Saturday, January 25, 2014 8:25 AM >>> *Subject:* [belajar-excel] Mencari Huruf Header Kolom >>> >>> >>> >>> >>> >> >> >

