Terimakasih mas Bgus dan Mr. Kid formulanya maknyoss....
Best Regards CW From: [email protected] [mailto:[email protected]] Sent: 30 September 2014 12:53 To: [email protected] Subject: Re: [belajar-excel] Mengambil nilai dari kolom ke baris Pak Cep; Coba begini, Array formula ya.. {=INDEX($B$4:$J$4,MATCH(0,COUNTIF($M$3:M3,$B$4:$J$4),0))} Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: 'cepwahyu' [email protected] [belajar-excel] <mailto:[email protected]%20[belajar-excel]> To: [email protected] Sent: Tuesday, September 30, 2014 12:09 PM Subject: [belajar-excel] Mengambil nilai dari kolom ke baris [1 Attachment] Dear Be-Exceller, Bagaimana mengambil nilai dari kolom menjadi baris dan men-summary-kan seperti contoh terlampir? Best Regards CW
