Super pak bagus, it's work.
Saya mau Tanya utk bagian yg ini (FIND(".",$H3,1)-1,FIND("N",$H3,1)-1)
Ini maksudnya jika ketemu karakter "." Dan "N"maka di kurangi 1 ?
Yg kurang 1-nya saya blm ngeh pak bagus.
Terimakasih pencerahannya ya J
Wassalam,
Mulki
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Friday, July 18, 2014 12:55 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Membaca data
Wa'alaykum salam warohmatullohi wabarokatuhu..
Pak Mulki;
Coba begini:
=INDEX('LIST
MASTER'!C$3:C$10,MATCH(LEFT($H3,IFERROR(FIND(".",$H3,1)-1,FIND("N",$H3,1)-1)
),'LIST MASTER'!$B$3:$B$10,0))
Copas kekanan dan kebawah
Wassalam
~ Bagus ~
----- Original Message -----
From: 'Mulki Akbar'
<mailto:mu...@aop.component.astra.co.id%20[belajar-excel]>
mu...@aop.component.astra.co.id [belajar-excel]
To: belajar-excel@yahoogroups.com
Sent: Friday, July 18, 2014 11:50 AM
Subject: [belajar-excel] Membaca data [1 Attachment]
Assalamu'alaikum Wr. Wb.
Mohon bantuan para guru & rekan2 B-XL-ers ttg kasus membaca data PART NO. yg
berbeda jumlah pengambilan karakter yg ingin dibaca.
Terimakasih atas bantuan dan pencerahannya.
Wassalam,
Mulki
