Hai Harry,Ini file jawaban saya atas pertanyaan seorang rekan di milis
tetangga.Coba disesuaikan dengan kebutuhan anda.
Salam,HK
From: "harry budiman sendtohar...@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 24 December 2014, 12:40
Subject: [belajar-excel] Formula List [1 Attachment]
Assalamualaikum
Salam Sejahtera
Mohon bantuan dan pencerahannya mengenai formula ketika kita memilih Nama Spv
tertentu maka nama2 tim nya akan berubah sesuai data masternya
Untuk lebih detail dpt dilihat pd attactment
Terima kasih atas bantuannya #yiv1268354755 #yiv1268354755 --
#yiv1268354755ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv1268354755 #yiv1268354755ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv1268354755 #yiv1268354755ygrp-mkp #yiv1268354755hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1268354755 #yiv1268354755ygrp-mkp #yiv1268354755ads
{margin-bottom:10px;}#yiv1268354755 #yiv1268354755ygrp-mkp .yiv1268354755ad
{padding:0 0;}#yiv1268354755 #yiv1268354755ygrp-mkp .yiv1268354755ad p
{margin:0;}#yiv1268354755 #yiv1268354755ygrp-mkp .yiv1268354755ad a
{color:#0000ff;text-decoration:none;}#yiv1268354755 #yiv1268354755ygrp-sponsor
#yiv1268354755ygrp-lc {font-family:Arial;}#yiv1268354755
#yiv1268354755ygrp-sponsor #yiv1268354755ygrp-lc #yiv1268354755hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1268354755
#yiv1268354755ygrp-sponsor #yiv1268354755ygrp-lc .yiv1268354755ad
{margin-bottom:10px;padding:0 0;}#yiv1268354755 #yiv1268354755actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1268354755
#yiv1268354755activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1268354755
#yiv1268354755activity span {font-weight:700;}#yiv1268354755
#yiv1268354755activity span:first-child
{text-transform:uppercase;}#yiv1268354755 #yiv1268354755activity span a
{color:#5085b6;text-decoration:none;}#yiv1268354755 #yiv1268354755activity span
span {color:#ff7900;}#yiv1268354755 #yiv1268354755activity span
.yiv1268354755underline {text-decoration:underline;}#yiv1268354755
.yiv1268354755attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1268354755 .yiv1268354755attach div a
{text-decoration:none;}#yiv1268354755 .yiv1268354755attach img
{border:none;padding-right:5px;}#yiv1268354755 .yiv1268354755attach label
{display:block;margin-bottom:5px;}#yiv1268354755 .yiv1268354755attach label a
{text-decoration:none;}#yiv1268354755 blockquote {margin:0 0 0
4px;}#yiv1268354755 .yiv1268354755bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1268354755
.yiv1268354755bold a {text-decoration:none;}#yiv1268354755 dd.yiv1268354755last
p a {font-family:Verdana;font-weight:700;}#yiv1268354755 dd.yiv1268354755last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1268354755
dd.yiv1268354755last p span.yiv1268354755yshortcuts
{margin-right:0;}#yiv1268354755 div.yiv1268354755attach-table div div a
{text-decoration:none;}#yiv1268354755 div.yiv1268354755attach-table
{width:400px;}#yiv1268354755 div.yiv1268354755file-title a, #yiv1268354755
div.yiv1268354755file-title a:active, #yiv1268354755
div.yiv1268354755file-title a:hover, #yiv1268354755 div.yiv1268354755file-title
a:visited {text-decoration:none;}#yiv1268354755 div.yiv1268354755photo-title a,
#yiv1268354755 div.yiv1268354755photo-title a:active, #yiv1268354755
div.yiv1268354755photo-title a:hover, #yiv1268354755
div.yiv1268354755photo-title a:visited {text-decoration:none;}#yiv1268354755
div#yiv1268354755ygrp-mlmsg #yiv1268354755ygrp-msg p a
span.yiv1268354755yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1268354755
.yiv1268354755green {color:#628c2a;}#yiv1268354755 .yiv1268354755MsoNormal
{margin:0 0 0 0;}#yiv1268354755 o {font-size:0;}#yiv1268354755
#yiv1268354755photos div {float:left;width:72px;}#yiv1268354755
#yiv1268354755photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1268354755
#yiv1268354755photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1268354755
#yiv1268354755reco-category {font-size:77%;}#yiv1268354755
#yiv1268354755reco-desc {font-size:77%;}#yiv1268354755 .yiv1268354755replbq
{margin:4px;}#yiv1268354755 #yiv1268354755ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1268354755 #yiv1268354755ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1268354755
#yiv1268354755ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1268354755
#yiv1268354755ygrp-mlmsg select, #yiv1268354755 input, #yiv1268354755 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1268354755
#yiv1268354755ygrp-mlmsg pre, #yiv1268354755 code {font:115%
monospace;}#yiv1268354755 #yiv1268354755ygrp-mlmsg *
{line-height:1.22em;}#yiv1268354755 #yiv1268354755ygrp-mlmsg #yiv1268354755logo
{padding-bottom:10px;}#yiv1268354755 #yiv1268354755ygrp-msg p a
{font-family:Verdana;}#yiv1268354755 #yiv1268354755ygrp-msg
p#yiv1268354755attach-count span {color:#1E66AE;font-weight:700;}#yiv1268354755
#yiv1268354755ygrp-reco #yiv1268354755reco-head
{color:#ff7900;font-weight:700;}#yiv1268354755 #yiv1268354755ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1268354755 #yiv1268354755ygrp-sponsor
#yiv1268354755ov li a {font-size:130%;text-decoration:none;}#yiv1268354755
#yiv1268354755ygrp-sponsor #yiv1268354755ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1268354755
#yiv1268354755ygrp-sponsor #yiv1268354755ov ul {margin:0;padding:0 0 0
8px;}#yiv1268354755 #yiv1268354755ygrp-text
{font-family:Georgia;}#yiv1268354755 #yiv1268354755ygrp-text p {margin:0 0 1em
0;}#yiv1268354755 #yiv1268354755ygrp-text tt {font-size:120%;}#yiv1268354755
#yiv1268354755ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1268354755
re_Help List.xlsx
Description: MS-Excel 2007 spreadsheet
