tinggal ngganti ISTEXT dengan ISNUMBER dan memperlebar jangkauan rumus =OFFSET(C5,,MAX(ISNUMBER(D5:K5)*(COLUMN(A:H))))
akhiri dengan CSE -zam- _____ From: [email protected] [mailto:[email protected]] On Behalf Of Afdhol Marthoni Sent: Friday, August 28, 2009 11:46 AM To: [email protected] Subject: RE: ]] XL-mania [[ rumus lokasi terakhir pemindahan pengiriman barang 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-
