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*. > ------------------------------------------------------------------------ > > ----- Original Message ----- > *From:* t0f1q <mailto:[email protected]> > *To:* belajar excel <mailto:[email protected]> > *Sent:* Sunday, February 21, 2010 6:28 AM > *Subject:* [belajar-excel] menggabungkan dua data yang berbeda > secara selang seling > > halo lagi master excel, saya ada persoalan bagaimana yah > menggabungkan > dua data pada 02 sheet menjadi 01 sheet dimana data tersebut terisi > secara selang seling antar masing2 sheet. > mohon bantuannya yah > thanks > > ------------------------------------ /---------------------------------------------------------------\ | 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/
