Pak Depi; Sila lihat file terlampir..
Wassalam ~ Bagus ~ ----- Original Message ----- From: depi Hariyanto [email protected] [belajar-excel] To: [email protected] Sent: Wednesday, October 29, 2014 6:57 AM Subject: Bls: [belajar-excel] Data Terpisah dear mr bagus, saya sudah coba tapi tidak bisa. tks. Pada Selasa, 28 Oktober 2014 15:46, "'Bagus' [email protected] [belajar-excel]" <[email protected]> menulis: Pak Depi; Coba begini, Array formula ya: =IFERROR(INDEX(C$6:C$12,SMALL(IF($E$6:$E$12<>$Q$6,ROW($C$6:$C$12)-ROW($C$5)),ROW(1:1))),"") Akhiri dengan menekan tiga tombol (Ctrl+Shift+Enter) Copas kekanan dan kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: depi Hariyanto [email protected] [belajar-excel] To: [email protected] Sent: Tuesday, October 28, 2014 2:03 PM Subject: [belajar-excel] Data Terpisah [1 Attachment] Kepada Master Excel, Mohon bantuannya untuk data terlampir, atas bantuannya saya ucapkan banyak terima kasih. salam Dep_Har
Bugs-Tanya.xlsx
Description: MS-Excel 2007 spreadsheet
