ajarin donk caranya mbak citi... siti Vi wrote: > > > q: "*ada gak* cara yang pake rumus makronya" > a: *"ada !" *(lebih tepatnya: "bisa dibuat") > ** > ** > ------------------------------------------------------------------------ > > ----- Original Message ----- > *From:* t0f1q <mailto:[email protected]> > *To:* [email protected] > <mailto:[email protected]> > *Sent:* Monday, February 22, 2010 3:46 AM > *Subject:* Re: [belajar-excel] menggabungkan dua data yang berbeda > secara selang seling > > makasih mbat citi, tapi *ada gak* cara yang pake rumus makronya? > biar nampak lebih keren gitu.. hehehe ;) > > siti Vi wrote: > > cara lain... > > *=INDIRECT(ADDRESS(* > > * > FLOOR(ROW(A1)-1,2)/2+2,COLUMN(A1),2,1,IF(MOD(ROW(A1),2)=1,"a","b")))* > > FORMULA INI > > ** *Universal *(cukup ditulis di satu cell dulu misal C17) lalu > dicopy > > ke cells di bawah > > & kanan nya dlm area data > > ** *Bukan Array Formula* > > ** *Tidak memerlukan kolom bantu*. > >
------------------------------------ /---------------------------------------------------------------\ | bergabung ke milis (subscribe) | | kirim mail kosong ke: [email protected] | | | | posting ke milis | | kirim kan ke: [email protected] | | | | melihat file archive / mendownload lampiran | | http://www.mail-archive.com/[email protected]/ | | | | menhubungi moderators & owners: | | [email protected] | | | | ExcelWeb <http://opi.110mb.com/> | \---------------------------------------------------------------/Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
