Luar biasa…Terima kasih Pak
Salam Yatno From: [email protected] [mailto:[email protected]] On Behalf Of ghozi alkatiri Sent: 17 September 2011 5:48 To: [email protected] Subject: Bls: [belajar-excel] Insert dg row kosong coba formula bebas dummy dan array formula awal di tulis di G5 =IFERROR(IF(ROWS(E$4:E4)=1;$A$5;IF(COUNTIF(E$3:E4;E4)<COUNTIF($A$5:$A$13;E4);E4;IF(COUNTIF(E$3:E4;E4)=COUNTIF($A$5:$A$13;E4);"";IF(COUNTIF(E$3:E3;E3)=COUNTIF($A$5:$A$13;E4);E3;INDEX($A$5:$A$13;MATCH(E3;$A$5:$A$13;0)+COUNTIF($A$5:$A$13;E3))))));"") copy ke bawah sampai tuntas tas. wassalam Ghozi Alkatiri --- Pada Jum, 16/9/11, Suyatno <[email protected]> menulis: Dari: Suyatno <[email protected]> Judul: [belajar-excel] Insert dg row kosong Kepada: [email protected] Tanggal: Jumat, 16 September, 2011, 6:01 PM Dear All Pakar Excel jika berkenan mohon solusi u/ kasus saya ( lihat attach ) Sebelum & sesudahnya terima kasih Salam Yatno --Mods-- mbok yao ada penjelasan dikit tentang kasusnya di body email. -------- _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1410 / Virus Database: 1520/3901 - Release Date: 09/16/11
