Dear Satya, Di cell L5, coba rumus panjang ini (akan jadi agak pendek jika data tabel dimodif)
=INDEX($D$3:$G$3,,1+IF(OFFSET($D$1,SUMPRODUCT((J5=$B$3:$B$24)*(I5=$C$3:$C$24)*ROW($C$3:$C$24))-1,,,)>K5,0,MATCH(K5,OFFSET($D$1,SUMPRODUCT((J5=$B$3:$B$24)*(I5=$C$3:$C$24)*ROW($C$3:$C$24))-1,,,3),1))) Blessings, tomz ----- Original Message ----- From: Satya Paramita To: [email protected] Sent: Thursday, July 01, 2010 1:28 AM Subject: ]] XL-mania [[ kategori km Dear Xl mania.. mohon bantuannya untuk problem saya terlampir.. mumet ternyata.... mohon petunjuknya ya... -- Regards, Mita
