makasih mas agung



________________________________
 From: agung aldhino <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Friday, April 12, 2013 4:20 PM
Subject: Bls: [belajar-excel] Re: Mencari data ganda
 


  
Dear Yudha
formula if dan countif bisa digunakan.
=IF(COUNTIFS($A$4:$A$16,A4,$B$4:$B$16,B4,$D$4:$D$16,D4)>1,"GANDA","")   
lebih jelasnya lihat file terlampir

Dari: yudha pramudji <[email protected]>
Kepada: "[email protected]" <[email protected]> 
Dikirim: Jumat, 12 April 2013 15:49
Judul: [belajar-excel] Re: Mencari data ganda

  
maaf terlupa attach filenya
 

Kirim email ke