Terimakasih Banyak Mas Ghozi
Assalamualaikum
    Pada Sabtu, 19 Oktober 2019 15.31.05 WIB, ghozi alkatiri 
ghozialkat...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> 
menulis:

  

 tulis di F3 (array formula)
=IFERROR(INDEX($D$3:$D$1296,MATCH(SUM(COUNTIF($D$3:$D$1296,F$2:F2)),COUNTIF($D$3:$D$1296,"<"&$D$3:$D$1296),),),"")

copy ke bawah
wassalam
Ghozi Alkatiri
    Pada Sabtu, 19 Oktober 2019 08.55.20 WIB, HAIRUL ALAM ha_m...@yahoo.co.id 
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

  

Salam para Master
Selamat Pagi, semoga selalu dalam keadaan sehat dan semangat
Terlampir data, bagaimana mengurutkan data sesuai nomor yang diinginkan dari 
kecil ke besar dengan rumus, Terimakasih banyak
AssalamualaikumHairul Alam      #yiv2131349457 #yiv2131349457 -- 
#yiv2131349457ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv2131349457 #yiv2131349457ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv2131349457 #yiv2131349457ygrp-mkp #yiv2131349457hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2131349457 #yiv2131349457ygrp-mkp #yiv2131349457ads 
{margin-bottom:10px;}#yiv2131349457 #yiv2131349457ygrp-mkp .yiv2131349457ad 
{padding:0 0;}#yiv2131349457 #yiv2131349457ygrp-mkp .yiv2131349457ad p 
{margin:0;}#yiv2131349457 #yiv2131349457ygrp-mkp .yiv2131349457ad a 
{color:#0000ff;text-decoration:none;}#yiv2131349457 #yiv2131349457ygrp-sponsor 
#yiv2131349457ygrp-lc {font-family:Arial;}#yiv2131349457 
#yiv2131349457ygrp-sponsor #yiv2131349457ygrp-lc #yiv2131349457hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2131349457 
#yiv2131349457ygrp-sponsor #yiv2131349457ygrp-lc .yiv2131349457ad 
{margin-bottom:10px;padding:0 0;}#yiv2131349457 #yiv2131349457actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2131349457 
#yiv2131349457activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2131349457
 #yiv2131349457activity span {font-weight:700;}#yiv2131349457 
#yiv2131349457activity span:first-child 
{text-transform:uppercase;}#yiv2131349457 #yiv2131349457activity span a 
{color:#5085b6;text-decoration:none;}#yiv2131349457 #yiv2131349457activity span 
span {color:#ff7900;}#yiv2131349457 #yiv2131349457activity span 
.yiv2131349457underline {text-decoration:underline;}#yiv2131349457 
.yiv2131349457attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2131349457 .yiv2131349457attach div a 
{text-decoration:none;}#yiv2131349457 .yiv2131349457attach img 
{border:none;padding-right:5px;}#yiv2131349457 .yiv2131349457attach label 
{display:block;margin-bottom:5px;}#yiv2131349457 .yiv2131349457attach label a 
{text-decoration:none;}#yiv2131349457 blockquote {margin:0 0 0 
4px;}#yiv2131349457 .yiv2131349457bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2131349457 
.yiv2131349457bold a {text-decoration:none;}#yiv2131349457 dd.yiv2131349457last 
p a {font-family:Verdana;font-weight:700;}#yiv2131349457 dd.yiv2131349457last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2131349457 
dd.yiv2131349457last p span.yiv2131349457yshortcuts 
{margin-right:0;}#yiv2131349457 div.yiv2131349457attach-table div div a 
{text-decoration:none;}#yiv2131349457 div.yiv2131349457attach-table 
{width:400px;}#yiv2131349457 div.yiv2131349457file-title a, #yiv2131349457 
div.yiv2131349457file-title a:active, #yiv2131349457 
div.yiv2131349457file-title a:hover, #yiv2131349457 div.yiv2131349457file-title 
a:visited {text-decoration:none;}#yiv2131349457 div.yiv2131349457photo-title a, 
#yiv2131349457 div.yiv2131349457photo-title a:active, #yiv2131349457 
div.yiv2131349457photo-title a:hover, #yiv2131349457 
div.yiv2131349457photo-title a:visited {text-decoration:none;}#yiv2131349457 
div#yiv2131349457ygrp-mlmsg #yiv2131349457ygrp-msg p a 
span.yiv2131349457yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2131349457 
...yiv2131349457green {color:#628c2a;}#yiv2131349457 .yiv2131349457MsoNormal 
{margin:0 0 0 0;}#yiv2131349457 o {font-size:0;}#yiv2131349457 
#yiv2131349457photos div {float:left;width:72px;}#yiv2131349457 
#yiv2131349457photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2131349457 
#yiv2131349457photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2131349457
 #yiv2131349457reco-category {font-size:77%;}#yiv2131349457 
#yiv2131349457reco-desc {font-size:77%;}#yiv2131349457 .yiv2131349457replbq 
{margin:4px;}#yiv2131349457 #yiv2131349457ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2131349457 #yiv2131349457ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2131349457 
#yiv2131349457ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2131349457 
#yiv2131349457ygrp-mlmsg select, #yiv2131349457 input, #yiv2131349457 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2131349457 
#yiv2131349457ygrp-mlmsg pre, #yiv2131349457 code {font:115% 
monospace;}#yiv2131349457 #yiv2131349457ygrp-mlmsg * 
{line-height:1.22em;}#yiv2131349457 #yiv2131349457ygrp-mlmsg #yiv2131349457logo 
{padding-bottom:10px;}#yiv2131349457 #yiv2131349457ygrp-msg p a 
{font-family:Verdana;}#yiv2131349457 #yiv2131349457ygrp-msg 
p#yiv2131349457attach-count span {color:#1E66AE;font-weight:700;}#yiv2131349457 
#yiv2131349457ygrp-reco #yiv2131349457reco-head 
{color:#ff7900;font-weight:700;}#yiv2131349457 #yiv2131349457ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv2131349457 #yiv2131349457ygrp-sponsor 
#yiv2131349457ov li a {font-size:130%;text-decoration:none;}#yiv2131349457 
#yiv2131349457ygrp-sponsor #yiv2131349457ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2131349457 
#yiv2131349457ygrp-sponsor #yiv2131349457ov ul {margin:0;padding:0 0 0 
8px;}#yiv2131349457 #yiv2131349457ygrp-text 
{font-family:Georgia;}#yiv2131349457 #yiv2131349457ygrp-text p {margin:0 0 1em 
0;}#yiv2131349457 #yiv2131349457ygrp-text tt {font-size:120%;}#yiv2131349457 
#yiv2131349457ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv2131349457   
  • [belajar-excel] u... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
    • Re: [belajar... ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]
      • Re: [bel... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
    • Re: [belajar... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]

Kirim email ke