ex mas kid: =INDEX($D6:$K6;MAX(IF(ISNUMBER(E6:K6);COLUMN($E6:$K6)-COLUMN($C6)))) ex siti =INDIRECT(ADDRESS(ROW();MAX(ISNUMBER(D5:K5)*COLUMN(D5:K5)))) ex pak zam =OFFSET(C5;;MAX(ISNUMBER(D5:J5)*(COLUMN(A:G)))) ex mas zain =OFFSET(C5;;MATCH(MAX(D5:K5);D5:K5;0)) semuanya array formula (di-enter dengan upacara khusus ) cell tempat rumus ditulis diformat tampilan DATE
2009/8/28 Afdhol Marthoni <[email protected]> > Bagaimana kalau yang ingin diambil tanggal terakhir pengiriman nya ? > Rgds > Afdhol > > From: [email protected] [mailto:[email protected]] On Behalf Of Ahmad Zamroni > Sent: 28 Agustus 2009 10:00 > To: [email protected] > Subject: RE: ]] XL-mania [[ rumus lokasi terakhir pemindahan pengiriman barang > alternatif formula > -zam-
