Waalaikumussalam Wr. Wb. Taqabbalallahu minna wa minkum File terlampir memanfaatkan sebuah kolom bantu.
Wassalamualaikum Wr. Wb., Kid. On Thu, Aug 23, 2012 at 1:36 PM, M. Ferdiansyah <[email protected]>wrote: > ** > > > Assalamualaikum, wr., wb., > Dear rekan" excel yg berbahagia, > > Sebelumnya Minal Aidin Walfaidzin, mohon maaf lahir & bathin, > selamat Hari Raya Idul Fitri 1433H. > > Selanjutnya langsung saja kepermasalahannya ya, saya mempunyai daftar > tagihan pada tabel 1, kemudian akan saya saring menjadi tabel 2 dengan > kriteria jika sudah lunas pada tabel 1 tidak terdaftar kembali pada tabel > 2, atau lebih jelasnya bisa dilihat dilampiran.. > > Mohon bantuannya, bisa dengan macro, pivot tabel, atau diharapkan formula > filternya saja.. > > Terimakasih, > > wassalam, > > Ferdy > > ____________ _________ _________ _________ _________ _________ _________ > Notice : This e-mail (and any attachment) is strictly confidential and > is intended only for the addressee(s)above. Is strictly prohibited to > forward, print, copy, or otherwise reproduce this message that would > allow it to be viewed by any individual not originally listed as > a recipient(s). If you have received this e-mail in error, please > immediately notify the sender and delete this message. The opinions > expressed in this e-mail (and any attachment) are those of the individual > sender and may not necessarily reflect the views of PT Pusri. > ____________ _________ _________ _________ _________ _________ _________ > >
re-Filter Data Dengan Kriteria Tertentu.xlsm
Description: Binary data
