Yth. Mr. Kid Assalaamu'alaikum Wr Wb Mohon bantuan penyelesaiannya.Kasus terlampir, merujuk penyelesaian dari Mr. Kid yang terdahulu, hasilnya ada yang tak sesuai.Hasil bisa sesuai keinginan, (dengan catatan) apabila kolom tanggal mulai harus di sort Oldest --> newest. Tetapi, kalau dengan solusi tersebut akan terasa sulit mengetahui keterangan deteksi tandem dikarenakan data tersusun urut sesuai kolom tanggal mulai. (data lumayan banyak)Keinginannya apabila kita menginput suatu data maka hasil keterangan deteksi tandem langsung diketahui tanpa harus data tersusun urut sesuai kolom tanggal mulai. Mohon berkenan memberi pencerahan atas kasus tersebut.
Terima kasih. Wassalaamu'alaikum Wr Wb Ari On Friday, March 16, 2018, 11:15:02 AM GMT+7, 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Wa'alaikumussalam wr wb File terlampir menggunakan kolom helper dan ada yang berisi array formula dengan running (resizing) references. Wassalamu'alaikum wr wb Kid 2018-03-01 13:08 GMT+07:00 cheivory_bri...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: Yth. B-Exceler Assalaamu'alaikum Wr Wb Mohon kiranya dapat dibantu mendapatkan informasi deteksi waktu tandem. Case terlampir. Terima kasih. Wassalaamu'alaikum Wr Wb Ari #yiv9842441458 #yiv9842441458 -- #yiv9842441458ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9842441458 #yiv9842441458ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9842441458 #yiv9842441458ygrp-mkp #yiv9842441458hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9842441458 #yiv9842441458ygrp-mkp #yiv9842441458ads {margin-bottom:10px;}#yiv9842441458 #yiv9842441458ygrp-mkp .yiv9842441458ad {padding:0 0;}#yiv9842441458 #yiv9842441458ygrp-mkp .yiv9842441458ad p {margin:0;}#yiv9842441458 #yiv9842441458ygrp-mkp .yiv9842441458ad a {color:#0000ff;text-decoration:none;}#yiv9842441458 #yiv9842441458ygrp-sponsor #yiv9842441458ygrp-lc {font-family:Arial;}#yiv9842441458 #yiv9842441458ygrp-sponsor #yiv9842441458ygrp-lc #yiv9842441458hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9842441458 #yiv9842441458ygrp-sponsor #yiv9842441458ygrp-lc .yiv9842441458ad {margin-bottom:10px;padding:0 0;}#yiv9842441458 #yiv9842441458actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9842441458 #yiv9842441458activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9842441458 #yiv9842441458activity span {font-weight:700;}#yiv9842441458 #yiv9842441458activity span:first-child {text-transform:uppercase;}#yiv9842441458 #yiv9842441458activity span a {color:#5085b6;text-decoration:none;}#yiv9842441458 #yiv9842441458activity span span {color:#ff7900;}#yiv9842441458 #yiv9842441458activity span .yiv9842441458underline {text-decoration:underline;}#yiv9842441458 .yiv9842441458attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9842441458 .yiv9842441458attach div a {text-decoration:none;}#yiv9842441458 .yiv9842441458attach img {border:none;padding-right:5px;}#yiv9842441458 .yiv9842441458attach label {display:block;margin-bottom:5px;}#yiv9842441458 .yiv9842441458attach label a {text-decoration:none;}#yiv9842441458 blockquote {margin:0 0 0 4px;}#yiv9842441458 .yiv9842441458bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9842441458 .yiv9842441458bold a {text-decoration:none;}#yiv9842441458 dd.yiv9842441458last p a {font-family:Verdana;font-weight:700;}#yiv9842441458 dd.yiv9842441458last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9842441458 dd.yiv9842441458last p span.yiv9842441458yshortcuts {margin-right:0;}#yiv9842441458 div.yiv9842441458attach-table div div a {text-decoration:none;}#yiv9842441458 div.yiv9842441458attach-table {width:400px;}#yiv9842441458 div.yiv9842441458file-title a, #yiv9842441458 div.yiv9842441458file-title a:active, #yiv9842441458 div.yiv9842441458file-title a:hover, #yiv9842441458 div.yiv9842441458file-title a:visited {text-decoration:none;}#yiv9842441458 div.yiv9842441458photo-title a, #yiv9842441458 div.yiv9842441458photo-title a:active, #yiv9842441458 div.yiv9842441458photo-title a:hover, #yiv9842441458 div...yiv9842441458photo-title a:visited {text-decoration:none;}#yiv9842441458 div#yiv9842441458ygrp-mlmsg #yiv9842441458ygrp-msg p a span.yiv9842441458yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9842441458 .yiv9842441458green {color:#628c2a;}#yiv9842441458 .yiv9842441458MsoNormal {margin:0 0 0 0;}#yiv9842441458 o {font-size:0;}#yiv9842441458 #yiv9842441458photos div {float:left;width:72px;}#yiv9842441458 #yiv9842441458photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9842441458 #yiv9842441458photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9842441458 #yiv9842441458reco-category {font-size:77%;}#yiv9842441458 #yiv9842441458reco-desc {font-size:77%;}#yiv9842441458 .yiv9842441458replbq {margin:4px;}#yiv9842441458 #yiv9842441458ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9842441458 #yiv9842441458ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9842441458 #yiv9842441458ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9842441458 #yiv9842441458ygrp-mlmsg select, #yiv9842441458 input, #yiv9842441458 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9842441458 #yiv9842441458ygrp-mlmsg pre, #yiv9842441458 code {font:115% monospace;}#yiv9842441458 #yiv9842441458ygrp-mlmsg * {line-height:1.22em;}#yiv9842441458 #yiv9842441458ygrp-mlmsg #yiv9842441458logo {padding-bottom:10px;}#yiv9842441458 #yiv9842441458ygrp-msg p a {font-family:Verdana;}#yiv9842441458 #yiv9842441458ygrp-msg p#yiv9842441458attach-count span {color:#1E66AE;font-weight:700;}#yiv9842441458 #yiv9842441458ygrp-reco #yiv9842441458reco-head {color:#ff7900;font-weight:700;}#yiv9842441458 #yiv9842441458ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9842441458 #yiv9842441458ygrp-sponsor #yiv9842441458ov li a {font-size:130%;text-decoration:none;}#yiv9842441458 #yiv9842441458ygrp-sponsor #yiv9842441458ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9842441458 #yiv9842441458ygrp-sponsor #yiv9842441458ov ul {margin:0;padding:0 0 0 8px;}#yiv9842441458 #yiv9842441458ygrp-text {font-family:Georgia;}#yiv9842441458 #yiv9842441458ygrp-text p {margin:0 0 1em 0;}#yiv9842441458 #yiv9842441458ygrp-text tt {font-size:120%;}#yiv9842441458 #yiv9842441458ygrp-vital ul li:last-child {border-right:none !important;}#yiv9842441458
re-deteksi tandem.xlsx
Description: MS-Excel 2007 spreadsheet