Untuk menghindari adanya nama yang sama,
=IFERROR(INDEX(MID(data!$D$2:$D$108,FIND("
",data!$D$2:$D$108,1)+1,5),MATCH(IF(LEN(D$3),D$3&D$4&$B5,C$3&D$4&$B5),DATEVALUE(data!$D$2:$D$108)&MID(data!$E$2:$E$108,FIND("
",data!$E$2:$E$108,1)+1,3)&data!$B$2:$B$108,0)),"")
ganti yang yang warna merah diatas menjadi:
=IFERROR(INDEX(MID(data!$D$2:$D$108,FIND("
",data!$D$2:$D$108,1)+1,5),MATCH(IF(LEN(D$3),D$3&D$4&$A5,C$3&D$4&$A5),DATEVALUE(data!$D$2:$D$108)&MID(data!$E$2:$E$108,FIND("
",data!$E$2:$E$108,1)+1,3)&data!$A$2:$A$108,0)),"")
Wassalam
~ Bagus ~
----- Original Message -----
From: Bagus
To: [email protected]
Sent: Tuesday, April 08, 2014 12:09 PM
Subject: Re: [belajar-excel] (unknown) [1 Attachment]
Hai Ferry;
Maunya pakai formula ya..
Sila lihat file terlampir..
semoga sesuai harapan
Wassalam
~ Bagus ~
----- Original Message -----
From: Ferry Alexander
To: [email protected]
Sent: Tuesday, April 08, 2014 12:46 AM
Subject: [belajar-excel] (unknown) [1 Attachment]
Dear Be-Excelers,
Mohon info bantuan formula untuk dari sheet "data" yang berupa data
vertikaldiubah menjadi data horizontal pertanggalseperti pada sheet "hitung".
terima kasih
file terlampir
rgds,
Ferry
