Coba gunakan formula:
{=MAX(IF($B$101=$B$3:$B$98;$E$3:$K$98;0))-MIN(IF(($B$101=$B$3:$B$98)*($B$101>1);$E$3:$K$98;9^99))}sayangnya array formula dan hanya berlaku untuk minggu 1, minggu 2 harus mengubah E3:K98 menjadi kolom selanjutnya On Mon, Nov 24, 2014 at 4:24 PM, Samsudin [email protected] [belajar-excel] <[email protected]> wrote: > > > *Assalamu’alaikum* > > > > *Dear All Master,* > > > > *Mohon bantuan dan pencerahannya untuk masalah yang saya hadapi seperti > terlampir pada file attachement.* > > > > *Atas perhatian dan pencerahannya.* > > > > > > *Wassalam,* > > > > *Samsudin, ST* > > > > O: +62 542 875 860 Ext :61519 | > > M: +62 811 2810 068 | +62 813 6914 7150 | email: [email protected] > > P Save a tree & save energy. Don't print this e-mail unless it's > really necessary. Go Green !!! > > ISO 9001 : 2008| ISO 14001 : 2004 | OHSAS 18001 : 2007 > > > > --------------------------------------------------------------------------------------------------- > > > This message (including any attachments) contains confidential information > intended > for a specific individual and purpose, and is protected by law. If you are > not the > intended recipient, you should delete this message and hereby notified that > any > disclosure, copying, or distribution of this message (or any part thereof), > or the > taking of any action based on it, is strictly prohibited. No liability or > responsibility > is accepted if information or data is, for whatever reason corrupted or does > not reach > its intended recipient. No warranty is given that this email is free of > viruses. The > views expressed in this email are, unless otherwise stated, those of the > author and > not those of the Company or its management. The Company reserves the right to > monitor, > intercept and block emails addressed to its users or take any other action in > accordance > with its email use policy. > > >
Jarak Tempuh.xlsx
Description: MS-Excel 2007 spreadsheet
