terima kasih semuanya....
mantap....


  ----- Original Message ----- 
  From: hendrik karnadi 
  To: [email protected] 
  Sent: Tuesday, July 31, 2012 5:11 PM
  Subject: Fw: [belajar-excel] mencocokan data


    

  Khusus untuk Text, hati2 dengan karakter kosong (spasi) dibelakang huruf.
  Untuk menceknya pakai formula : = Len(text).


  File terlampir.


  Salam,
  Hendrik Karnadi




  ----- Forwarded Message -----
  From: Fano The Miner <[email protected]>
  To: [email protected] 
  Sent: Tuesday, 31 July 2012, 15:39
  Subject: RE: [belajar-excel] mencocokan data



    
  Coba dengan rumus ini

  =IF(A3=B3,"COCOK","TIDAK COCOK")

  Salam
  fano

  From: [email protected] [mailto:[email protected]] On 
Behalf Of MIKE
  Sent: Tuesday, July 31, 2012 12:39 PM
  To: [email protected]
  Subject: [belajar-excel] mencocokan data

   
  Mohon bantuannya rumus yg digunakan untuk mencocokan data...

  tq
  mike












































PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER:  This email and any files 
transmitted with it are confidential andintended solely for the use of the 
individual or entity to whom theyare addressed. If you have received this email 
in error please notifythe system manager. This message contains confidential 
informationand is intended only for the individual named. If you are not 
thenamed addressee you should not disseminate, distribute or copy thise-mail. 
Please notify the sender immediately by e-mail if you
 havereceived this e-mail by mistake and delete this e-mail from yoursystem. If 
you are not the intended recipient you are notified thatdisclosing, copying, 
distributing or taking any action in reliance onthe contents of this 
information is strictly prohibited. 





  
PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER:

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager. This message contains confidential information
and is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on
the contents of this information is strictly prohibited.

Kirim email ke