Suwun atas ilmu barunya Pak nangagus <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2017-08-10 6:34 GMT+07:00 nangagus nanga...@gmail.com [belajar-excel] < belajar-excel@yahoogroups.com>: > > > Dear Abu, > > Dapat juga digunakan formula bukan array (tanpa CSE): > ketik di di G7: =IF(B7=INDEX($M$6:$M$17;$G$4);INDEX($N$6:$N$17;$G$4);"") > salam > > On 8/7/2017 3:45 PM, Abu Abdillaah abuabdillaa...@gmail.com > [belajar-excel] wrote: > > > Dear Pak heru mulyono > > Apakah seperti ini yang diinginkan?? > File terlampir > > > > 2017-08-07 14:43 GMT+07:00 heru mulyono hmulyon...@gmail.com > [belajar-excel] <belajar-excel@yahoogroups.com>: > >> >> Permasalah ada file terlampir >> > > > >