Coba juga dengan formula:
=LOOKUP(C3,{0,3,6,9,12},{"E","D","C","B","A"})
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
On Behalf Of M. Ferdiansyah
Sent: Wednesday, May 11, 2011 9:19 AM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Kode
Dear Bu Niki,
Mungkin sudah dijawab oleh rekan-rekan B-Excel lainnya..
Tp izinkan saya untuk mencoba menyederhanakan jawabannya dengan bantuan
define name, tp rumusnya ngambil dari Mr. Kid (hehehhee)..
semoga membantu..
File terlampir..
> Temen2 B-excel...tlg bantuannya ya...utk lbh jelas casenya ada di attach
> file
>
> trims
>
>
>
>
>
____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________
