Bls: Bls: [belajar-excel] Lookup mencari posisi meja

2013-07-01 Terurut Topik ghozi alkatiri
dipahami. wassalam Ghozi Alkatiri Dari: Emi Kepada: "belajar-excel@yahoogroups.com" Dikirim: Senin, 1 Juli 2013 20:58 Judul: Re: Bls: [belajar-excel] Lookup mencari posisi meja   Pak Ghozi, Mohon pencerahan, dalam  rumus di bawah apa artinya I

Re: Bls: [belajar-excel] Lookup mencari posisi meja

2013-07-01 Terurut Topik Emi
From: ghozi alkatiri To: "belajar-excel@yahoogroups.com" Sent: Saturday, June 29, 2013 9:32 AM Subject: Bls: [belajar-excel] Lookup mencari posisi meja   tulis di D23 =INDEX($A$1:$G$17;INDEX({2;10};MATCH(SUMPRODUCT(($C$2:$G$17=C23)*ROW($C$2:$G$17));{2;10}));SUMPRODUCT((

Re: Bls: [belajar-excel] Lookup mencari posisi meja

2013-07-01 Terurut Topik Emi
Terima kasih Pak Ghozi. From: ghozi alkatiri To: "belajar-excel@yahoogroups.com" Sent: Saturday, June 29, 2013 9:32 AM Subject: Bls: [belajar-excel] Lookup mencari posisi meja   tulis di D23 =INDEX($A$1:$G$17;INDEX({2;10};MATCH(SUMPRODUCT(($C$2

Bls: [belajar-excel] Lookup mencari posisi meja

2013-06-28 Terurut Topik ghozi alkatiri
tulis di D23 =INDEX($A$1:$G$17;INDEX({2;10};MATCH(SUMPRODUCT(($C$2:$G$17=C23)*ROW($C$2:$G$17));{2;10}));SUMPRODUCT(($C$2:$G$17=C23)*COLUMN($C$2:$G$17))) copy ke bawah wassalam Ghozi Alkatiri Dari: Emi Kepada: "belajar-excel@yahoogroups.com" Dikirim: Juma