Begini :
=INDEX($E$1:$E$5,MAX(INDEX(($A$2:$D$5=I2)*ROW($A$2:$D$5),0,0)))

2017-09-29 18:57 GMT+07:00 shenly_excelma...@yahoo.co.id [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> aduh maaf mr , file nya blm terlapir,
> ini sya lampirkan master
>
> 
>
  • [belaja... shenly_excelma...@yahoo.co.id [belajar-excel]
    • Re... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
      • ... shenly_excelma...@yahoo.co.id [belajar-excel]
        • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
          • ... shenly_excelma...@yahoo.co.id [belajar-excel]
            • ... nangagus nanga...@gmail.com [belajar-excel]
              • ... shenly_excelma...@yahoo.co.id [belajar-excel]
              • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
              • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
              • ... 'Heru Safrudin' fcprocessing.bisiked...@bisi.co.id [belajar-excel]
              • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
                • ... 'Heru Safrudin' fcprocessing.bisiked...@bisi.co.id [belajar-excel]
                • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]

Kirim email ke