Assalamualaikum Maaf mengganggu dan bila pertanyaan saya kurang jelas, maksud nya seperti contoh terlampir Terimakasih Banyak Wassalamualaikum
Pada Kamis, 22 Oktober 2015 14:21, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
wa'alaikumussalam wr wb
Maaf, rada gagal paham atas penjelasan Anda nih.
Bagaimana jika Anda coba lebih dulu di file lampiran dalam email tempo lalu.
Jika ada yang kurang pas, silakan lampirkan hasil uji coba Anda tersebut ke
milis.
Wassalamu'alaikum wr wb.
Kid
On Thu, Oct 22, 2015 at 1:56 PM, HAIRUL ALAM [email protected]
[belajar-excel] <[email protected]> wrote:
Assalamualaikum
Maaf Saya Mengganggu
Terimakasih atas pencerahannya, bila data saya rubah input tanggalnya diluar
dari contoh 1 sd 4 = 4, 5 sd 6 = 0, 7sd9 =3, 10 = 0, 11 sd 16 =6, 17=0, 18sd22
= 5, namun saya lihat untuk range nya yang saya beri warna merah tetap di buat
manual, kalau misal data 1 sd 22 bukan range tsb diatas misalakan 1sd2, 4sd6,
8sd12, 14sd22 diisi nilai apakah output bisa otomatis menujjukan seperti range
yang saya beri warna kuning
Wassalamualaikum
Pada Selasa, 20 Oktober 2015 10:07, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa'alaikumussalam wr wb
File terlampir dengan banyak sekali kolom bantu sebagai pembentuk tabel data
yang utuh.
Wassalamu'alaikum wr wb
Kid
2015-10-20 6:09 GMT+07:00 HAIRUL ALAM [email protected] [belajar-excel]
<[email protected]>:
Assalamualaikum
Nama Saya : Hairul Alam
Saya memiliki masalah tentang excel untuk mengelompokkan data secara otomatis
seperti contoh terlampir, mohon pencerahannya
TerimakasihWassalamualaikum
#yiv3845244223 #yiv3845244223 -- #yiv3845244223ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3845244223
#yiv3845244223ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3845244223
#yiv3845244223ygrp-mkp #yiv3845244223hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3845244223 #yiv3845244223ygrp-mkp #yiv3845244223ads
{margin-bottom:10px;}#yiv3845244223 #yiv3845244223ygrp-mkp .yiv3845244223ad
{padding:0 0;}#yiv3845244223 #yiv3845244223ygrp-mkp .yiv3845244223ad p
{margin:0;}#yiv3845244223 #yiv3845244223ygrp-mkp .yiv3845244223ad a
{color:#0000ff;text-decoration:none;}#yiv3845244223 #yiv3845244223ygrp-sponsor
#yiv3845244223ygrp-lc {font-family:Arial;}#yiv3845244223
#yiv3845244223ygrp-sponsor #yiv3845244223ygrp-lc #yiv3845244223hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3845244223
#yiv3845244223ygrp-sponsor #yiv3845244223ygrp-lc .yiv3845244223ad
{margin-bottom:10px;padding:0 0;}#yiv3845244223 #yiv3845244223actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3845244223
#yiv3845244223activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3845244223
#yiv3845244223activity span {font-weight:700;}#yiv3845244223
#yiv3845244223activity span:first-child
{text-transform:uppercase;}#yiv3845244223 #yiv3845244223activity span a
{color:#5085b6;text-decoration:none;}#yiv3845244223 #yiv3845244223activity span
span {color:#ff7900;}#yiv3845244223 #yiv3845244223activity span
.yiv3845244223underline {text-decoration:underline;}#yiv3845244223
.yiv3845244223attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3845244223 .yiv3845244223attach div a
{text-decoration:none;}#yiv3845244223 .yiv3845244223attach img
{border:none;padding-right:5px;}#yiv3845244223 .yiv3845244223attach label
{display:block;margin-bottom:5px;}#yiv3845244223 .yiv3845244223attach label a
{text-decoration:none;}#yiv3845244223 blockquote {margin:0 0 0
4px;}#yiv3845244223 .yiv3845244223bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3845244223
.yiv3845244223bold a {text-decoration:none;}#yiv3845244223 dd.yiv3845244223last
p a {font-family:Verdana;font-weight:700;}#yiv3845244223 dd.yiv3845244223last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3845244223
dd.yiv3845244223last p span.yiv3845244223yshortcuts
{margin-right:0;}#yiv3845244223 div.yiv3845244223attach-table div div a
{text-decoration:none;}#yiv3845244223 div.yiv3845244223attach-table
{width:400px;}#yiv3845244223 div.yiv3845244223file-title a, #yiv3845244223
div.yiv3845244223file-title a:active, #yiv3845244223
div.yiv3845244223file-title a:hover, #yiv3845244223 div.yiv3845244223file-title
a:visited {text-decoration:none;}#yiv3845244223 div.yiv3845244223photo-title a,
#yiv3845244223 div.yiv3845244223photo-title a:active, #yiv3845244223
div.yiv3845244223photo-title a:hover, #yiv3845244223
div.yiv3845244223photo-title a:visited {text-decoration:none;}#yiv3845244223
div#yiv3845244223ygrp-mlmsg #yiv3845244223ygrp-msg p a
span.yiv3845244223yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3845244223
.yiv3845244223green {color:#628c2a;}#yiv3845244223 .yiv3845244223MsoNormal
{margin:0 0 0 0;}#yiv3845244223 o {font-size:0;}#yiv3845244223
#yiv3845244223photos div {float:left;width:72px;}#yiv3845244223
#yiv3845244223photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3845244223
#yiv3845244223photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3845244223
#yiv3845244223reco-category {font-size:77%;}#yiv3845244223
#yiv3845244223reco-desc {font-size:77%;}#yiv3845244223 .yiv3845244223replbq
{margin:4px;}#yiv3845244223 #yiv3845244223ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3845244223 #yiv3845244223ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3845244223
#yiv3845244223ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3845244223
#yiv3845244223ygrp-mlmsg select, #yiv3845244223 input, #yiv3845244223 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3845244223
#yiv3845244223ygrp-mlmsg pre, #yiv3845244223 code {font:115%
monospace;}#yiv3845244223 #yiv3845244223ygrp-mlmsg *
{line-height:1.22em;}#yiv3845244223 #yiv3845244223ygrp-mlmsg #yiv3845244223logo
{padding-bottom:10px;}#yiv3845244223 #yiv3845244223ygrp-msg p a
{font-family:Verdana;}#yiv3845244223 #yiv3845244223ygrp-msg
p#yiv3845244223attach-count span {color:#1E66AE;font-weight:700;}#yiv3845244223
#yiv3845244223ygrp-reco #yiv3845244223reco-head
{color:#ff7900;font-weight:700;}#yiv3845244223 #yiv3845244223ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3845244223 #yiv3845244223ygrp-sponsor
#yiv3845244223ov li a {font-size:130%;text-decoration:none;}#yiv3845244223
#yiv3845244223ygrp-sponsor #yiv3845244223ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3845244223
#yiv3845244223ygrp-sponsor #yiv3845244223ov ul {margin:0;padding:0 0 0
8px;}#yiv3845244223 #yiv3845244223ygrp-text
{font-family:Georgia;}#yiv3845244223 #yiv3845244223ygrp-text p {margin:0 0 1em
0;}#yiv3845244223 #yiv3845244223ygrp-text tt {font-size:120%;}#yiv3845244223
#yiv3845244223ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3845244223
PENGELOMPOKAN.xlsx
Description: MS-Excel 2007 spreadsheet
