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 >> >> >> >> >> > >

