Wah...mantap... Terimakasih banyak Mr. Kid..
Bisa dijelasin gak cara baca rumusnya? Maklum... J Rgds, Febri From: [email protected] [mailto:[email protected]] On Behalf Of Mr. Kid Sent: 09 Desember 2012 19:51 To: [email protected] Subject: Re: [belajar-excel] Deadline Pak Febri, Coba : 1. hasilnya bertipe numerik kemudian di format cell : =E4-LOOKUP(9^9,A4:D4) kemudian atur format cells -> tab number -> custom -> tulis : "> Dead Line";"< Dead Line";"= Dead Line" lalu, copy ke baris lain 2. hasilnya bertipe teks =LOOKUP(E4-LOOKUP(9^9,A4:D4),{-999999,0,1},{"<","=",">"}) & " Dead Line" Wassalam, Kid. 2012/12/8 Wahyudi Febrian <[email protected]<mailto:[email protected]>> Dear All Master, Mohon bantuannya untuk rumus permasalahan terlampir. Ditunggu slalu advicenya.. J Rgds, Febri __________ Information from ESET NOD32 Antivirus, version of virus signature database 7710 (20121120) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 7710 (20121120) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

