hai vir,
coba deh ganti formula yang panjang itu dengan
=LOOKUP(2;1/(SEARCH($I$3:$I$24;C3));$J$3:$J$24)
bila reg seting kompi setempat english ganti titik koma ";" menjadi koma "," br,
odong nando
Dari: "Virdania Ve [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Rabu, 13 September 2017 16:55
Judul: [belajar-excel] Tanya rumus search data dengan banyak kategori [1
Attachment]
Salam.
Dear master excel.
Mohon bantuannya dong, rumusan apa yang harus saya pakai jika saya ingin
mengelompokkan banyak data ke beberapa grup dengan keyword ada dalam data
tersebut (tapi keyword tidak di urutan depan atau belakang). Saya sudah mencoba
memakai rumusan search, tapi karna ada banyak grup dengan keyword yang berbeda
maka saya menggunakan banyak sekali iferror(iferror(search(xxxxx), dan terasa
seperti mengelompokan manual.
Tolong solusinya master.
(file terlampir)
Trimakasih. #yiv6950259914 #yiv6950259914 -- #yiv6950259914ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv6950259914 #yiv6950259914ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv6950259914 #yiv6950259914ygrp-mkp #yiv6950259914hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6950259914 #yiv6950259914ygrp-mkp #yiv6950259914ads
{margin-bottom:10px;}#yiv6950259914 #yiv6950259914ygrp-mkp .yiv6950259914ad
{padding:0 0;}#yiv6950259914 #yiv6950259914ygrp-mkp .yiv6950259914ad p
{margin:0;}#yiv6950259914 #yiv6950259914ygrp-mkp .yiv6950259914ad a
{color:#0000ff;text-decoration:none;}#yiv6950259914 #yiv6950259914ygrp-sponsor
#yiv6950259914ygrp-lc {font-family:Arial;}#yiv6950259914
#yiv6950259914ygrp-sponsor #yiv6950259914ygrp-lc #yiv6950259914hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6950259914
#yiv6950259914ygrp-sponsor #yiv6950259914ygrp-lc .yiv6950259914ad
{margin-bottom:10px;padding:0 0;}#yiv6950259914 #yiv6950259914actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6950259914
#yiv6950259914activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6950259914
#yiv6950259914activity span {font-weight:700;}#yiv6950259914
#yiv6950259914activity span:first-child
{text-transform:uppercase;}#yiv6950259914 #yiv6950259914activity span a
{color:#5085b6;text-decoration:none;}#yiv6950259914 #yiv6950259914activity span
span {color:#ff7900;}#yiv6950259914 #yiv6950259914activity span
.yiv6950259914underline {text-decoration:underline;}#yiv6950259914
.yiv6950259914attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6950259914 .yiv6950259914attach div a
{text-decoration:none;}#yiv6950259914 .yiv6950259914attach img
{border:none;padding-right:5px;}#yiv6950259914 .yiv6950259914attach label
{display:block;margin-bottom:5px;}#yiv6950259914 .yiv6950259914attach label a
{text-decoration:none;}#yiv6950259914 blockquote {margin:0 0 0
4px;}#yiv6950259914 .yiv6950259914bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6950259914
.yiv6950259914bold a {text-decoration:none;}#yiv6950259914 dd.yiv6950259914last
p a {font-family:Verdana;font-weight:700;}#yiv6950259914 dd.yiv6950259914last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6950259914
dd.yiv6950259914last p span.yiv6950259914yshortcuts
{margin-right:0;}#yiv6950259914 div.yiv6950259914attach-table div div a
{text-decoration:none;}#yiv6950259914 div.yiv6950259914attach-table
{width:400px;}#yiv6950259914 div.yiv6950259914file-title a, #yiv6950259914
div.yiv6950259914file-title a:active, #yiv6950259914
div.yiv6950259914file-title a:hover, #yiv6950259914 div.yiv6950259914file-title
a:visited {text-decoration:none;}#yiv6950259914 div.yiv6950259914photo-title a,
#yiv6950259914 div.yiv6950259914photo-title a:active, #yiv6950259914
div.yiv6950259914photo-title a:hover, #yiv6950259914
div.yiv6950259914photo-title a:visited {text-decoration:none;}#yiv6950259914
div#yiv6950259914ygrp-mlmsg #yiv6950259914ygrp-msg p a
span.yiv6950259914yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6950259914
.yiv6950259914green {color:#628c2a;}#yiv6950259914 .yiv6950259914MsoNormal
{margin:0 0 0 0;}#yiv6950259914 o {font-size:0;}#yiv6950259914
#yiv6950259914photos div {float:left;width:72px;}#yiv6950259914
#yiv6950259914photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6950259914
#yiv6950259914photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6950259914
#yiv6950259914reco-category {font-size:77%;}#yiv6950259914
#yiv6950259914reco-desc {font-size:77%;}#yiv6950259914 .yiv6950259914replbq
{margin:4px;}#yiv6950259914 #yiv6950259914ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6950259914 #yiv6950259914ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6950259914
#yiv6950259914ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6950259914
#yiv6950259914ygrp-mlmsg select, #yiv6950259914 input, #yiv6950259914 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6950259914
#yiv6950259914ygrp-mlmsg pre, #yiv6950259914 code {font:115%
monospace;}#yiv6950259914 #yiv6950259914ygrp-mlmsg *
{line-height:1.22em;}#yiv6950259914 #yiv6950259914ygrp-mlmsg #yiv6950259914logo
{padding-bottom:10px;}#yiv6950259914 #yiv6950259914ygrp-msg p a
{font-family:Verdana;}#yiv6950259914 #yiv6950259914ygrp-msg
p#yiv6950259914attach-count span {color:#1E66AE;font-weight:700;}#yiv6950259914
#yiv6950259914ygrp-reco #yiv6950259914reco-head
{color:#ff7900;font-weight:700;}#yiv6950259914 #yiv6950259914ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6950259914 #yiv6950259914ygrp-sponsor
#yiv6950259914ov li a {font-size:130%;text-decoration:none;}#yiv6950259914
#yiv6950259914ygrp-sponsor #yiv6950259914ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6950259914
#yiv6950259914ygrp-sponsor #yiv6950259914ov ul {margin:0;padding:0 0 0
8px;}#yiv6950259914 #yiv6950259914ygrp-text
{font-family:Georgia;}#yiv6950259914 #yiv6950259914ygrp-text p {margin:0 0 1em
0;}#yiv6950259914 #yiv6950259914ygrp-text tt {font-size:120%;}#yiv6950259914
#yiv6950259914ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6950259914
