Bls: ]] XL-mania [[ Delete Row Secara "otomatis"

 

sheet tempat data asal saya  beri nama sheet problem

sheet tempat solusi yang diinginkan saya beri nama solusi

tulis formula awal di B6 sheet solusi (formula array)

{=IFERROR(INDEX(PROBLEM!B$6:B$13;SMALL(IF(LEN(PROBLEM!$H$6:$H$13&PROBLEM!$I$6:$I$13&PROBLEM!$J$6:$J$13&PROBLEM!$K$6:$K$13)>0;MATCH(PROBLEM!$B$6:$B$13;PROBLEM!$B$6:$B$13;0));ROW(1:1)));"")}

copy ke kanan dan ke bawah

insya Allah kasus clear

wassalam

Ghozi Alkatiri

---

Dari: Adhe Tirtana <adtirta99@yahoo.co.uk>
Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Dikirim: Senin, 1 Oktober 2012 14:03
Judul: ]] XL-mania [[ Delete Row Secara "otomatis"

 

Dear

mumet jg klo manual delete nya...

So...Mohon bantuannya, bgm formula jika ingin menghapus suatu Row yg tidak memiliki nilai pada kolom2 nya

terlampir data sy...tks

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 42

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Selamat jalan SitiVi, semoga bahagia di sisi-Nya...               |
| Maaf moderasi lemooOooOott... momods siboek                       |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___