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]
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
