Coba begini, Array formula ya.. =INDEX(LEFT($A$3:$A$10,5),MATCH(0,COUNTIF($E$2:E2,LEFT($A$3:$A$10,5)),0))
Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: 'cepwahyu' [email protected] [belajar-excel] To: [email protected] Sent: Wednesday, September 24, 2014 9:47 AM Subject: RE: [belajar-excel] Mengambil Nilai Terimakasih banyak atas responsnya pak Bagus. Untuk pertanyaan yang pertama bagaimana solusinya pak Bagus? Best Regards CW From: [email protected] [mailto:[email protected]] Sent: 24 September 2014 8:51 To: [email protected] Subject: Re: [belajar-excel] Mengambil Nilai CW; Coba begini: =REPT("A ",MIN(1,COUNTIF($A$3:$A$10,E3&" A")))&REPT("G ",MIN(1,COUNTIF($A$3:$A$10,E3&" G")))&REPT("N ",MIN(1,COUNTIF($A$3:$A$10,E3&" N")))&REPT("P ",MIN(1,COUNTIF($A$3:$A$10,E3&" P")))&REPT("Q ",MIN(1,COUNTIF($A$3:$A$10,E3&" Q*"))) Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: 'cepwahyu' [email protected] [belajar-excel] To: [email protected] Sent: Wednesday, September 24, 2014 8:03 AM Subject: [belajar-excel] Mengambil Nilai [1 Attachment] Dear Be-Exceller Saya ada kesulitan dalam mengambil nilai seperti dalam file terlampir. Adakah yang bisa membantu? Best Regards CW
