Re: ]] XL-mania [[ hlookup terbalik gan

[Tommy]

Dear Mas Yusuf,

Bisa dicoba formula dibawah ini:


Last date : 7 february      <------ (array formula) =MAX((B1:L1)*(B2:L2>0))

Qty           : 3                        <------ (formula biasa) 
=HLOOKUP(B5,B1:L2,2,)


Blessings,
tomz

  ----- Original Message ----- 
  From: Yusuf 
  To: XL-mania@yahoogroups.com 
  Cc: 'muhammad yusuf' 
  Sent: Thursday, April 12, 2012 1:35 PM
  Subject: ]] XL-mania [[ hlookup terbalik gan


    

  --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








  

xhlookup kebalik.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet