mencoba yang nggak array Lokasi Terakhir: =OFFSET(C5,,MATCH(MAX(D5:K5),D5:K5,0)-1)
Tanggal Terakhir: =OFFSET(C5,,MATCH(MAX(D5:K5),D5:K5,0)) --- In [email protected], siti <setiyowati.d...@...> wrote: > > 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 <afdholmarth...@...> > > 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- >
