Pak Musriadi;
Coba begini: =IF(COUNTIF(B$19:B19,D3)>1,LOOKUP(2,1/($B$19:$B$31=D3),$A$19:$A$31),INDEX($A$19:$A$31,MATCH(D3,$B$19:$B$31,0))) Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: MSJ Planners Tyres [email protected] [XL-mania] To: [email protected] Sent: Saturday, June 21, 2014 4:16 PM Subject: ]] XL-mania [[ Nilai Boleh Sama namun Nama Gak Boleh [1 Attachment] Team XL, Mohon dibantu untuk yang terlampir. Trim’s Salam, Musriadi ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________
