Apa sudah dicoba cara berikut ini: Cara 1. formula way semisal =INDEX(Sheet1!K1:K29;SMALL(IF((Sheet1!I1:I29="Division");ROW(1:29));ROW()-2)) yang merupakan array formula Cara 2. memanfaatkan Data>Filter>Autofilter, kemudian pilih filter data yang NonBlanks atau pilih custom pabila diperlukan, setelah itu lakukan teknik copy paste dari hasil filternya. Dengan sedikit tambahan teknik, cara ini lebih cepat tanpa copy paste satu persatu. Cara 3. belum nemu cara laen yang lebih baik, mungkin temans yg lainnya ada cara yg lebih baik...
>semoga bermanfaat "Muljana, Andrew" <[email protected]> wrote: Mau Tanya. Ada cara yang baik dan cepat untuk mensumarise data agar dapat mengambil data yang dibutuhkan saja. Pada data yang terletak pada beberapa baris. Bisa dilihat pada attachment contoh kasusnya. Thx Best Regards, Andrew Muljana Staff, Audit KPMG, Siddharta Siddharta & Widjaja Registered Public Accountants 32nd Floor Wisma GKBI 28, Jl. Jend Sudirman Jakarta 10210, Indonesia Phone: +62 21 574 2333, 574 2888 (ext 5233) Fax : +62 21 574 1777, 574 2777 Email : [email protected] *********************************************************************** The information in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorized. If you have received this communication in error, please address with the subject heading "Received in error," send to [email protected], then delete the e-mail and destroy any copies of it. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any opinions or advice contained in this e-mail are subject to the terms and conditions expressed in the governing KPMG client engagement letter. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the firm are neither given nor endorsed by it. KPMG cannot guarantee that e-mail communications are secure or error-free, as information could be intercepted, corrupted, amended, lost, destroyed, arrive late or incomplete, or contain viruses. Siddharta Siddharta Widjaja - Registered Public Accountants is an Indonesian partnership and a member firm of KPMG International, a Swiss cooperative. KPMG International is a Swiss cooperative. Member firms of the KPMG network of independent firms are affiliated with KPMG International. KPMG International provides no client services. This footnote also confirms that this e-mail message has been swept by Postini for the presence of computer viruses. See www.postini.com for more information. ***********************************************************************
