lho, jadi udah tahu ya caranya? trus nanya buat apaan dong? :bingungs Uploaded with ImageShack.us jadi waktu box diatas ane klik kluar nama2nya & kalo di klik bisa langsung ngefilter datanya. sori ngerepotin gan :D coba lihat postingan ane di sini. spt itukah? atau jgn2 ente udah tahu jawabanny...
seperti ini mungkin ya: caranya: klik di salah satu sel yg berisi data masuk ke ribbon Data > Filter (2007) atau menu Data > Filter > Filter (2003) atau tekan Ctrl+Shift+L data tersebut akan otomatis difilter oleh excel.
trus nantinya ane mau dari data tadi bisa keluar fee tiap pegawai dari berbagai event selama sebulan gan mohon pencerahan ya gan....kmaren ane sempet diajarin pake SUMIF dan VLOOKUP tapi ane lupa caranya :hammer saya asumsikan tabel yg di bawah ini terletak di worksheet yg berbeda dengan DATA ...
kalaupun mau tetap dibuat satu kolom (misalnya saja "PRICE"), agan tetap harus sertakan penanda atau identifier yg menunjukkan apakah harga yg dimasukkan itu dalam IDR atau SGD. kalau tidak "dibantu" oleh data entry, excel tidak akan tahu apakah yg dimasukkan itu dalam IDR at...
bisa diperjelas agak lebih detil lagi gan? yg difilter apa? outputnya apa? skrinsyot contoh bisa dilampirin mungkin, spy jelas? SUMIF? emang bentuk datanya spt apa gan? coba skrinsyot (ato file-nya lbh baik) dilampirin, plus output yg diinginkan spt apa. ini file di server/network ato di local...
hahaha.. memang banyak jalan menuju roma, gan :D ada banyak cara bahkan untuk mencapai hasil yg persis sama. yg saya komenin cuma beda asumsinya kok :Peace: :cendols :cendols :cendols
hmm.. kayanya musti bikin list baru yg tidak ada nama yg sama. coba ini deh: di luar data yg sdh ada, misalnya saja di I2 (I1 biarkan kosong), masukkan: =I1+IF(COUNTIF(D$2:D2,D2)>1,0,1) /* hitung ada brp jumlah kota dgn nama yg berbeda. */ lalu di J2, masukkan: =IF(ROWS(I$2:I2)>MAX(I:I),...
wedew.. kok bisa gitu ya gan? gimana kalo agan kirim/upload file tsb spy bisa kita sama2 lihat apa masalahnya? (kalo gak rahasia :D) maksud agan si wiraniaga yang bernama "Santi"? mungkin itu karena si "Santi" ada di dua kota, Jakarta dan Yogyakarta? CMIIW silakan dilihat l...
gimana rumusnya ya, supaya berat produk yg di sheet3 otomatis masuk ke sheet1 :mewek di Sheet 1 cell C4, agan ketik: =Sheet3!B3 setelah itu, agan copy formula itu ke cell C5 - C8 di Sheet 1. beres! :) Pertanyaannya bagaimana caranya ane merapikan tulisan itu, contoh, pada alenia terakhir kan s...
di Ms Word gak ada fasilitas utk itu, gan/sis. kalo mau, convert aja ke PDF, trus diatur document security di properties-nya. ane asumsikan "075202410999" di sini sebagai text (krn ada angka "0" di depan) dan terletak di cell A1 ya gan: =IF(MID(A1,3,3)="520","...
:ngakaks no, we're not angry. we're smart enough to know that fumes from vehicles and industries; solvents and coolants from hairsprays and air-cons; particulate matters from asbestos; dangerous gases from weapons; and smoke from burning domestic garbage :hammers and forest fires, not ...
those 'crap' threads may not mean much to you, but they do have their educational values the way i see it. they give people the opportunity to practice expressing their opinions, getting used to using fixed phrases like 'in my opinion', debating, contradicting others, etc. tru...
polygamy? yes, if both the man and the women want it. no if they don't. as for the "surplus" of women, this is probably why it was/is permitted in the first place. another alternative solution would be for guys to prepare themselves to marry more than one woman at different times, ...
well, i don't know if we can close the main forum and keep the subforums open :) how would you prevent people from posting a new thread in the main?
hahahaha! i knew it'd eventually come to this :ngakaks first of all, ask yourself the following questions: how good are you at translating? (i'm not talking only about your level of english here; only your clients/other translators can assess that.) do you have any experience? (the more...
i charge by the minute of the film duration (starting from the very first minute, i don't care if it's only the opening credit or even the FBI warning, all the way to the last, even if it's just the AHA certification). i charge up to double for rush work. i double that even further...
