Salam Mr.Kid
Terimakasih Banyak
Assalamualaikum
    Pada Kamis, 17 Oktober 2019 09.00.48 GMT+7, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

  

=SUMPRODUCT(1*(MATCH(C5:P5,C5:P5,0)=COLUMN(C5:P5)-COLUMN(B5)))

On Wed, Oct 16, 2019 at 5:45 PM HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] 
<belajar-excel@yahoogroups.com> wrote:

  

 Salam Pak Hendrik
TerimakasihPak Hendrikuntuk rumus tersebut berfungsi menentukan nilai terbesar, 
sedangkan yang sayamaksud itu seperti terlampir, jadi berdasarkan jumlah kode 
yang berbeda Pak

Terimakasih
AssalamualaikumHairul
    Pada Rabu, 16 Oktober 2019 14.29.56 WIB, hendrik karnadi 
hendrikkarn...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> 
menulis:

  

 Dear Hairul,Coba ketik di R5 :=MAX(B5:P5)lalu dicopy ke bawah.
Salam,HK


    Pada Rabu, 16 Oktober 2019 14.14...59 GMT+7, HAIRUL ALAM 
ha_m...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

  

Salam Rekan - Rekan BeExcel
Rumus apa yang digunakan jika masalah seperti data terlampir ;

jika data pada range C s/d P sepertidiatas, bagaimana rumusnya agar nilai sama 
seperti kolom Q, rumus apa yangdigunakan COUNTIF atau SUMIF

kolom B no 1 range C s/d P terdapat 2code angka 1 & 2 maka di R 5 nilainya 
samadengan 2

kolom B no 2 range C s/d P terdapat 4code angka 1,2,3 & 4 maka di R 6 nilainya 
samadengan 4

kolom B no 3 range C s/d P terdapat 6code angka 1,2,3,4,5 & 6 maka di R 7 
nilainya samadengan 6

Terimakasih
AssalmualaikumHairul Alam

 
  #yiv3125855631 #yiv3125855631 -- #yiv3125855631ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3125855631 
#yiv3125855631ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3125855631 
#yiv3125855631ygrp-mkp #yiv3125855631hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3125855631 #yiv3125855631ygrp-mkp #yiv3125855631ads 
{margin-bottom:10px;}#yiv3125855631 #yiv3125855631ygrp-mkp ...yiv3125855631ad 
{padding:0 0;}#yiv3125855631 #yiv3125855631ygrp-mkp .yiv3125855631ad p 
{margin:0;}#yiv3125855631 #yiv3125855631ygrp-mkp .yiv3125855631ad a 
{color:#0000ff;text-decoration:none;}#yiv3125855631 #yiv3125855631ygrp-sponsor 
#yiv3125855631ygrp-lc {font-family:Arial;}#yiv3125855631 
#yiv3125855631ygrp-sponsor #yiv3125855631ygrp-lc #yiv3125855631hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3125855631 
#yiv3125855631ygrp-sponsor #yiv3125855631ygrp-lc .yiv3125855631ad 
{margin-bottom:10px;padding:0 0;}#yiv3125855631 #yiv3125855631actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3125855631 
#yiv3125855631activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3125855631
 #yiv3125855631activity span {font-weight:700;}#yiv3125855631 
#yiv3125855631activity span:first-child 
{text-transform:uppercase;}#yiv3125855631 #yiv3125855631activity span a 
{color:#5085b6;text-decoration:none;}#yiv3125855631 #yiv3125855631activity span 
span {color:#ff7900;}#yiv3125855631 #yiv3125855631activity span 
.yiv3125855631underline {text-decoration:underline;}#yiv3125855631 
.yiv3125855631attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3125855631 .yiv3125855631attach div a 
{text-decoration:none;}#yiv3125855631 .yiv3125855631attach img 
{border:none;padding-right:5px;}#yiv3125855631 .yiv3125855631attach label 
{display:block;margin-bottom:5px;}#yiv3125855631 .yiv3125855631attach label a 
{text-decoration:none;}#yiv3125855631 blockquote {margin:0 0 0 
4px;}#yiv3125855631 .yiv3125855631bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3125855631 
.yiv3125855631bold a {text-decoration:none;}#yiv3125855631 dd.yiv3125855631last 
p a {font-family:Verdana;font-weight:700;}#yiv3125855631 dd.yiv3125855631last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3125855631 
dd.yiv3125855631last p span.yiv3125855631yshortcuts 
{margin-right:0;}#yiv3125855631 div.yiv3125855631attach-table div div a 
{text-decoration:none;}#yiv3125855631 div.yiv3125855631attach-table 
{width:400px;}#yiv3125855631 div.yiv3125855631file-title a, #yiv3125855631 
div.yiv3125855631file-title a:active, #yiv3125855631 
div.yiv3125855631file-title a:hover, #yiv3125855631 div.yiv3125855631file-title 
a:visited {text-decoration:none;}#yiv3125855631 div.yiv3125855631photo-title a, 
#yiv3125855631 div.yiv3125855631photo-title a:active, #yiv3125855631 
div.yiv3125855631photo-title a:hover, #yiv3125855631 
div.yiv3125855631photo-title a:visited {text-decoration:none;}#yiv3125855631 
div#yiv3125855631ygrp-mlmsg #yiv3125855631ygrp-msg p a 
span.yiv3125855631yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3125855631 
.yiv3125855631green {color:#628c2a;}#yiv3125855631 .yiv3125855631MsoNormal 
{margin:0 0 0 0;}#yiv3125855631 o {font-size:0;}#yiv3125855631 
#yiv3125855631photos div {float:left;width:72px;}#yiv3125855631 
#yiv3125855631photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3125855631 
#yiv3125855631photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3125855631
 #yiv3125855631reco-category {font-size:77%;}#yiv3125855631 
#yiv3125855631reco-desc {font-size:77%;}#yiv3125855631 .yiv3125855631replbq 
{margin:4px;}#yiv3125855631 #yiv3125855631ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3125855631 #yiv3125855631ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3125855631 
#yiv3125855631ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3125855631 
#yiv3125855631ygrp-mlmsg select, #yiv3125855631 input, #yiv3125855631 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3125855631 
#yiv3125855631ygrp-mlmsg pre, #yiv3125855631 code {font:115% 
monospace;}#yiv3125855631 #yiv3125855631ygrp-mlmsg * 
{line-height:1.22em;}#yiv3125855631 #yiv3125855631ygrp-mlmsg #yiv3125855631logo 
{padding-bottom:10px;}#yiv3125855631 #yiv3125855631ygrp-msg p a 
{font-family:Verdana;}#yiv3125855631 #yiv3125855631ygrp-msg 
p#yiv3125855631attach-count span {color:#1E66AE;font-weight:700;}#yiv3125855631 
#yiv3125855631ygrp-reco #yiv3125855631reco-head 
{color:#ff7900;font-weight:700;}#yiv3125855631 #yiv3125855631ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv3125855631 #yiv3125855631ygrp-sponsor 
#yiv3125855631ov li a {font-size:130%;text-decoration:none;}#yiv3125855631 
#yiv3125855631ygrp-sponsor #yiv3125855631ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3125855631 
#yiv3125855631ygrp-sponsor #yiv3125855631ov ul {margin:0;padding:0 0 0 
8px;}#yiv3125855631 #yiv3125855631ygrp-text 
{font-family:Georgia;}#yiv3125855631 #yiv3125855631ygrp-text p {margin:0 0 1em 
0;}#yiv3125855631 #yiv3125855631ygrp-text tt {font-size:120%;}#yiv3125855631 
#yiv3125855631ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv3125855631   
  • [belajar-excel] M... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
    • Re: [belajar... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
      • Re: [bel... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
        • Re: ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
          • ... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
      • Re: [bel... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]

Kirim email ke