> Dear rekan Xl-er > > Saya menemui kesulitan menemukan formula untuk menyortir data pada sheet > terlampir, > > Bila shortir dalam kondisi 1 kolom saya sudah bisa tapi dengan kondisi > terlampir, dah pusing di cari jalan keluarnya. > > Kalo pake satu kolom masih bisa pake rumus contoh > > =INDEX(IF($a2:$a100="",$A$3,$A2:$a100),MATCH(0,COUNTIF($e$3:e3,IF($a2:$G100="",$a$3,$G2:$G100)),0)) > > Nah kalo selain rumus diatas udah ga tau lagi deh :(((( > > > > Mohon bantuannya.ya rekan rekan. > > > > Thanks in advance > > aditia> > <<sortir data.xls>>
___________________________________________________________________________________ CONFIDENTIALITY NOTICE This message and its attachments (if any) may contain confidential,proprietary or legally privileged information and it is intended only forthe use of the addressee named above. No confidentiality or privilegeis waived or lost by any mistransmission.All reply messages and/or all attachments included, and transmitted incoming and/or outcoming from/to the Prysmian Company could be know from its .If you are not the intended recipient of this message you are herebynotified that you must not use, disseminate, copy it in any form or takeany action in reliance on it. If you have received this message in error,please, delete it (and any copies of it) and kindly inform the sender, of thise-mail, by replying or go to http://www.prysmian.com/ on "contact us".
sortir data.xls
Description: sortir data.xls
