terimakasih sebelumnya..om agus..atas koreksinya,, iya seharusnya data salah,karena untuk M003 tidak ada di Kelopok Ket ( cell D6 )sebenarnya gak ada masalah tidak harus memakai IF,yang penting sesuai dengan harapan,,hehehe ini saya lampirkan kembali file nya
terimakasih Pada Jumat, 31 Agustus 2018 20.52.41 GMT+7, Agus nanga...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis: Dear Ahmad, Apakah threat ini hanya dapat diselesaikan dengan IF? mungkinkah tanpa menggunakan If sama sekali? Mohon maaf saya kurang paham dengan cell G6, kenapa ada tanda centang (V) padahal di keterangan tidak ada M003? Lampiran tidak sesuai dengan permintaan karena di G6 tidak ada centang dan dinyatakan salah. formula dapat diperpendek jika menggunakan tabel bantu. =IFERROR(ROMAN((AND(FIND(F$2,$D3,1),$C3>CHOOSE(COLUMN(A1),8,0,0,5,0),$C3<CHOOSE(COLUMN(A1),100,8,0,100,5),INDEX($F$1:$I$1,,3*INT((COLUMN(A1)+2)/3)-2)=$B3)*5)),"") Salam Kenang Agus On 8/31/2018 09:08, achmad adi dido...@ymail.com [belajar-excel] wrote: Dear Master, dengan hormat..ini saya menemui kesulitan ketika mencari kesamaan data lebih jelasnya ini saya lampirkan data nya sebelumnya terimakasih #yiv9778960057 #yiv9778960057 -- #yiv9778960057ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9778960057 #yiv9778960057ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9778960057 #yiv9778960057ygrp-mkp #yiv9778960057hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9778960057 #yiv9778960057ygrp-mkp #yiv9778960057ads {margin-bottom:10px;}#yiv9778960057 #yiv9778960057ygrp-mkp .yiv9778960057ad {padding:0 0;}#yiv9778960057 #yiv9778960057ygrp-mkp .yiv9778960057ad p {margin:0;}#yiv9778960057 #yiv9778960057ygrp-mkp .yiv9778960057ad a {color:#0000ff;text-decoration:none;}#yiv9778960057 #yiv9778960057ygrp-sponsor #yiv9778960057ygrp-lc {font-family:Arial;}#yiv9778960057 #yiv9778960057ygrp-sponsor #yiv9778960057ygrp-lc #yiv9778960057hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9778960057 #yiv9778960057ygrp-sponsor #yiv9778960057ygrp-lc .yiv9778960057ad {margin-bottom:10px;padding:0 0;}#yiv9778960057 #yiv9778960057actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9778960057 #yiv9778960057activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9778960057 #yiv9778960057activity span {font-weight:700;}#yiv9778960057 #yiv9778960057activity span:first-child {text-transform:uppercase;}#yiv9778960057 #yiv9778960057activity span a {color:#5085b6;text-decoration:none;}#yiv9778960057 #yiv9778960057activity span span {color:#ff7900;}#yiv9778960057 #yiv9778960057activity span .yiv9778960057underline {text-decoration:underline;}#yiv9778960057 .yiv9778960057attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9778960057 .yiv9778960057attach div a {text-decoration:none;}#yiv9778960057 .yiv9778960057attach img {border:none;padding-right:5px;}#yiv9778960057 .yiv9778960057attach label {display:block;margin-bottom:5px;}#yiv9778960057 .yiv9778960057attach label a {text-decoration:none;}#yiv9778960057 blockquote {margin:0 0 0 4px;}#yiv9778960057 .yiv9778960057bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9778960057 .yiv9778960057bold a {text-decoration:none;}#yiv9778960057 dd.yiv9778960057last p a {font-family:Verdana;font-weight:700;}#yiv9778960057 dd.yiv9778960057last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9778960057 dd.yiv9778960057last p span.yiv9778960057yshortcuts {margin-right:0;}#yiv9778960057 div.yiv9778960057attach-table div div a {text-decoration:none;}#yiv9778960057 div.yiv9778960057attach-table {width:400px;}#yiv9778960057 div.yiv9778960057file-title a, #yiv9778960057 div.yiv9778960057file-title a:active, #yiv9778960057 div.yiv9778960057file-title a:hover, #yiv9778960057 div.yiv9778960057file-title a:visited {text-decoration:none;}#yiv9778960057 div.yiv9778960057photo-title a, #yiv9778960057 div.yiv9778960057photo-title a:active, #yiv9778960057 div.yiv9778960057photo-title a:hover, #yiv9778960057 div.yiv9778960057photo-title a:visited {text-decoration:none;}#yiv9778960057 div#yiv9778960057ygrp-mlmsg #yiv9778960057ygrp-msg p a span.yiv9778960057yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9778960057 .yiv9778960057green {color:#628c2a;}#yiv9778960057 .yiv9778960057MsoNormal {margin:0 0 0 0;}#yiv9778960057 o {font-size:0;}#yiv9778960057 #yiv9778960057photos div {float:left;width:72px;}#yiv9778960057 #yiv9778960057photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9778960057 #yiv9778960057photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9778960057 #yiv9778960057reco-category {font-size:77%;}#yiv9778960057 #yiv9778960057reco-desc {font-size:77%;}#yiv9778960057 .yiv9778960057replbq {margin:4px;}#yiv9778960057 #yiv9778960057ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9778960057 #yiv9778960057ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9778960057 #yiv9778960057ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9778960057 #yiv9778960057ygrp-mlmsg select, #yiv9778960057 input, #yiv9778960057 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9778960057 #yiv9778960057ygrp-mlmsg pre, #yiv9778960057 code {font:115% monospace;}#yiv9778960057 #yiv9778960057ygrp-mlmsg * {line-height:1.22em;}#yiv9778960057 #yiv9778960057ygrp-mlmsg #yiv9778960057logo {padding-bottom:10px;}#yiv9778960057 #yiv9778960057ygrp-msg p a {font-family:Verdana;}#yiv9778960057 #yiv9778960057ygrp-msg p#yiv9778960057attach-count span {color:#1E66AE;font-weight:700;}#yiv9778960057 #yiv9778960057ygrp-reco #yiv9778960057reco-head {color:#ff7900;font-weight:700;}#yiv9778960057 #yiv9778960057ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9778960057 #yiv9778960057ygrp-sponsor #yiv9778960057ov li a {font-size:130%;text-decoration:none;}#yiv9778960057 #yiv9778960057ygrp-sponsor #yiv9778960057ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9778960057 #yiv9778960057ygrp-sponsor #yiv9778960057ov ul {margin:0;padding:0 0 0 8px;}#yiv9778960057 #yiv9778960057ygrp-text {font-family:Georgia;}#yiv9778960057 #yiv9778960057ygrp-text p {margin:0 0 1em 0;}#yiv9778960057 #yiv9778960057ygrp-text tt {font-size:120%;}#yiv9778960057 #yiv9778960057ygrp-vital ul li:last-child {border-right:none !important;}#yiv9778960057
IF.xlsx
Description: MS-Excel 2007 spreadsheet