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  #yiv0226895623 #yiv0226895623 -- 
#yiv0226895623ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv0226895623 #yiv0226895623ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv0226895623 #yiv0226895623ygrp-mkp #yiv0226895623hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0226895623 #yiv0226895623ygrp-mkp #yiv0226895623ads 
{margin-bottom:10px;}#yiv0226895623 #yiv0226895623ygrp-mkp .yiv0226895623ad 
{padding:0 0;}#yiv0226895623 #yiv0226895623ygrp-mkp .yiv0226895623ad p 
{margin:0;}#yiv0226895623 #yiv0226895623ygrp-mkp .yiv0226895623ad a 
{color:#0000ff;text-decoration:none;}#yiv0226895623 #yiv0226895623ygrp-sponsor 
#yiv0226895623ygrp-lc {font-family:Arial;}#yiv0226895623 
#yiv0226895623ygrp-sponsor #yiv0226895623ygrp-lc #yiv0226895623hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0226895623 
#yiv0226895623ygrp-sponsor #yiv0226895623ygrp-lc .yiv0226895623ad 
{margin-bottom:10px;padding:0 0;}#yiv0226895623 #yiv0226895623actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0226895623 
#yiv0226895623activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0226895623
 #yiv0226895623activity span {font-weight:700;}#yiv0226895623 
#yiv0226895623activity span:first-child 
{text-transform:uppercase;}#yiv0226895623 #yiv0226895623activity span a 
{color:#5085b6;text-decoration:none;}#yiv0226895623 #yiv0226895623activity span 
span {color:#ff7900;}#yiv0226895623 #yiv0226895623activity span 
.yiv0226895623underline {text-decoration:underline;}#yiv0226895623 
.yiv0226895623attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0226895623 .yiv0226895623attach div a 
{text-decoration:none;}#yiv0226895623 .yiv0226895623attach img 
{border:none;padding-right:5px;}#yiv0226895623 .yiv0226895623attach label 
{display:block;margin-bottom:5px;}#yiv0226895623 .yiv0226895623attach label a 
{text-decoration:none;}#yiv0226895623 blockquote {margin:0 0 0 
4px;}#yiv0226895623 .yiv0226895623bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0226895623 
.yiv0226895623bold a {text-decoration:none;}#yiv0226895623 dd.yiv0226895623last 
p a {font-family:Verdana;font-weight:700;}#yiv0226895623 dd.yiv0226895623last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0226895623 
dd.yiv0226895623last p span.yiv0226895623yshortcuts 
{margin-right:0;}#yiv0226895623 div.yiv0226895623attach-table div div a 
{text-decoration:none;}#yiv0226895623 div.yiv0226895623attach-table 
{width:400px;}#yiv0226895623 div.yiv0226895623file-title a, #yiv0226895623 
div.yiv0226895623file-title a:active, #yiv0226895623 
div.yiv0226895623file-title a:hover, #yiv0226895623 div.yiv0226895623file-title 
a:visited {text-decoration:none;}#yiv0226895623 div.yiv0226895623photo-title a, 
#yiv0226895623 div.yiv0226895623photo-title a:active, #yiv0226895623 
div.yiv0226895623photo-title a:hover, #yiv0226895623 
div.yiv0226895623photo-title a:visited {text-decoration:none;}#yiv0226895623 
div#yiv0226895623ygrp-mlmsg #yiv0226895623ygrp-msg p a 
span.yiv0226895623yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0226895623 
..yiv0226895623green {color:#628c2a;}#yiv0226895623 .yiv0226895623MsoNormal 
{margin:0 0 0 0;}#yiv0226895623 o {font-size:0;}#yiv0226895623 
#yiv0226895623photos div {float:left;width:72px;}#yiv0226895623 
#yiv0226895623photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0226895623 
#yiv0226895623photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0226895623
 #yiv0226895623reco-category {font-size:77%;}#yiv0226895623 
#yiv0226895623reco-desc {font-size:77%;}#yiv0226895623 .yiv0226895623replbq 
{margin:4px;}#yiv0226895623 #yiv0226895623ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0226895623 #yiv0226895623ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0226895623 
#yiv0226895623ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0226895623 
#yiv0226895623ygrp-mlmsg select, #yiv0226895623 input, #yiv0226895623 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0226895623 
#yiv0226895623ygrp-mlmsg pre, #yiv0226895623 code {font:115% 
monospace;}#yiv0226895623 #yiv0226895623ygrp-mlmsg * 
{line-height:1.22em;}#yiv0226895623 #yiv0226895623ygrp-mlmsg #yiv0226895623logo 
{padding-bottom:10px;}#yiv0226895623 #yiv0226895623ygrp-msg p a 
{font-family:Verdana;}#yiv0226895623 #yiv0226895623ygrp-msg 
p#yiv0226895623attach-count span {color:#1E66AE;font-weight:700;}#yiv0226895623 
#yiv0226895623ygrp-reco #yiv0226895623reco-head 
{color:#ff7900;font-weight:700;}#yiv0226895623 #yiv0226895623ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv0226895623 #yiv0226895623ygrp-sponsor 
#yiv0226895623ov li a {font-size:130%;text-decoration:none;}#yiv0226895623 
#yiv0226895623ygrp-sponsor #yiv0226895623ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0226895623 
#yiv0226895623ygrp-sponsor #yiv0226895623ov ul {margin:0;padding:0 0 0 
8px;}#yiv0226895623 #yiv0226895623ygrp-text 
{font-family:Georgia;}#yiv0226895623 #yiv0226895623ygrp-text p {margin:0 0 1em 
0;}#yiv0226895623 #yiv0226895623ygrp-text tt {font-size:120%;}#yiv0226895623 
#yiv0226895623ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv0226895623   
  • [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