--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1f465089-dd74-4b32-a86c-1e8b811a3b7e%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CADRUV1r0GdVRp0keWLJGxM%2BsZRSHAb0d4VXAbY84%3D2zt7GRySg%40mail.gmail.com.
Formula dari pak Bagus dan pak Sandy bekerja dengan baik sesuai harapan, terima kasih bantuannya ya..cuma yg menarik dari pilihan formula ada dikit perbedaan dan kebetulan sy tidak paham☺
dari pak Bagus
=INDEX('Data base'!$C$4:$AC$68,MATCH(D4&F4,'Data base'!$A$4:$A$68&'Data base'!$B$4:$B$68,0),MATCH(C4&E4&G4,'Data base'!$C$1:$AC$1&'Data base'!$C$2:$AC$2&'Data base'!$C$3:$AC$3,0))
dari pak Sandy =INDEX('Data base'!$C$4:$AC$68,MATCH(1,($D4='Data base'!$A$4:$A$68)*($F4='Data base'!$B$4:$B$68),0),MATCH(1,($C4='Data base'!$C$1:$AC$1)*($E4='Data base'!$C$2:$AC$2)*($G4='Data base'!$C$3:$AC$3),0)) dgn cara berbeda namun mirip ke 2 nya adalah solusi, cuma cara mengartikan ke 2 formula ini dalam pemahaman bahasa bagaimana yah..salam,jayadi
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAEPgWdkJQCU-pagn44oc9Qg_x-4MAExyGkOuRgsMhgknDS%2BApw%40mail.gmail.com.
--Ijay
Formula dari pak Bagus dan pak Sandy bekerja dengan baik sesuai harapan, terima kasih bantuannya ya..cuma yg menarik dari pilihan formula ada dikit perbedaan dan kebetulan sy tidak paham☺ dari pak Bagus |
=INDEX('Data base'!$C$4:$AC$68,MATCH(D4&F4,'Data base'!$A$4:$A$68&'Data base'!$B$4:$B$68,0),MATCH(C4&E4&G4,'Data base'!$C$1:$AC$1&'Data base'!$C$2:$AC$2&'Data base'!$C$3:$AC$3,0)) |
dari pak Sandy |
||||||||
=INDEX('Data base'!$C$4:$AC$68,MATCH(1,($D4='Data base'!$A$4:$A$68)*($F4='Data base'!$B$4:$B$68),0),MATCH(1,($C4='Data base'!$C$1:$AC$1)*($E4='Data base'!$C$2:$AC$2)*($G4='Data base'!$C$3:$AC$3),0)) | ||||||||
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAEPgWdkJQCU-pagn44oc9Qg_x-4MAExyGkOuRgsMhgknDS%2BApw%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAEPgWd%3DaHJUad5Swecmt2yMhX_4rezncDQE%3DceQ%3Dp3NpjV2r%2BQ%40mail.gmail.com.