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

Kirim email ke