Dear Rano
Mungkin jawabannya spt ini: 1. Insert 1 kolom di kolom A 2. Masukkan formula =CONCATENATE(B19,C19) sebagai cell kunci 3. Jika dirubah susunannya spt di kolom Q bagaimana?..karena logikanya hampir sama, jika harus seperti format asal tinggal diambil saja dari kolom R (=R6, dst) 4. Untuk Kolom R diisi Formula Look up dari cell kunci di kolom A tadi =IF(ISNA(VLOOKUP(CONCATENATE($Q3,R$5),$A$21:$D$39,4,FALSE())),"",(VLOOKUP(CO NCATENATE($Q3,R$5),$A$21:$D$39,4,FALSE()))) Silakan di trial..maaf jika tidak sesuai. Regards Malkan From: [email protected] [mailto:[email protected]] On Behalf Of rano Sent: Thursday, March 11, 2010 11:09 AM To: [email protected] Cc: mohon tidak cc ke individu Subject: ]] XL-mania [[ cell kuningku ini harusnya pakai rumus apa ya? Importance: High Dear XL-Mania minta tolong formula-nya untuk mengisi cell kuning dunk ...!! pleaseeeee.... Thanks yah .. rano Reply <mailto:[email protected]?subject=cell%20kuningku%20ini%20harusnya%20 pakai%20rumus%20apa%20ya?> to sender | Reply <mailto:[email protected]?subject=cell%20kuningku%20ini%20harusnya%20 pakai%20rumus%20apa%20ya?> to group | Reply <http://groups.yahoo.com/group/XL-mania/post;_ylc=X3oDMTJyc2VzYW5xBF9TAzk3Mz U5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMxNTE2NgRzZWMDZn RyBHNsawNycGx5BHN0aW1lAzEyNjgyODI5Mjk-?act=reply&messageNum=15166> via web post | <http://groups.yahoo.com/group/XL-mania/post;_ylc=X3oDMTJmZ2puNjFyBF9TAzk3Mz U5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBH N0aW1lAzEyNjgyODI5Mjk-> Start a New Topic Messages <http://groups.yahoo.com/group/XL-mania/message/15166;_ylc=X3oDMTM3MnVhZzJrB F9TAzk3MzU5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMxNTE2N gRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEyNjgyODI5MjkEdHBjSWQDMTUxNjY-> in this topic (1) Recent Activity:
