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
