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

Kirim email ke