biasanya pakai array formula seperti ini.. *=INDEX(B1:L1, MAX( (B2:L2>0) * TRANSPOSE(ROW(1:11)) ))*
dan *=INDEX(B2:L2, MAX( (B2:L2>0) * TRANSPOSE(ROW(1:11)) ))* On Thu, Apr 12, 2012 at 11:35 AM, Yusuf <[email protected]>wrote: > ** > > --Malu bertanya kerja 3 hari—**** > > Dear xl-ers** > > ** > > Ada yang bikin saya kerja 3 hari , hlookup**** > > date**** > > 1-Feb**** > > 2-Feb**** > > 3-Feb**** > > 4-Feb**** > > 5-Feb**** > > 6-Feb**** > > 7-Feb**** > > 8-Feb**** > > 9-Feb**** > > 10-Feb**** > > 11-Feb**** > > Product**** > > status**** > > output**** > > 2**** > > 7**** > > 5**** > > 3**** > > 1**** > > 0**** > > 3**** > > 0**** > > 0**** > > 0**** > > 0**** > > 21**** > > complete**** > > ** ** > > Bagaimana caranya agar saya bisa dapaat data ini :**** > > Last date : 7 february** > > ** > > Qty : 3 >
hlookup kebalik (Mencari Data non-Kosong yg Nilai Letak KOLOM-nya tertinggi ~Rr).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
