Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An :-). Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi 'IF' bisa membantu.
Salam, Agoes ----- Original Message ----- From: "qpass" <[EMAIL PROTECTED]> To: <ITCENTER@yahoogroups.com> Sent: Thursday, November 24, 2005 8:57 AM Subject: [ITCENTER] formula di Excel > Sya punya masalah dengan excel begini ceritanya: > > kolom A B C > 11 22 > 22 11 > Hasil yang diinginkan > > A B C > 11 22 11 > 22 11 22 > > gimana caranya yah selian short ini contoh gampanya aja.. > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang > tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## > Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > Yahoo! Groups Links > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. http://dk.mail.yahoo.com -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/