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      #yiv4606899853 #yiv4606899853 -- 
#yiv4606899853ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv4606899853 #yiv4606899853ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv4606899853 #yiv4606899853ygrp-mkp #yiv4606899853hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4606899853 #yiv4606899853ygrp-mkp #yiv4606899853ads 
{margin-bottom:10px;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad 
{padding:0 0;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad p 
{margin:0;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad a 
{color:#0000ff;text-decoration:none;}#yiv4606899853 #yiv4606899853ygrp-sponsor 
#yiv4606899853ygrp-lc {font-family:Arial;}#yiv4606899853 
#yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc #yiv4606899853hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4606899853 
#yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc .yiv4606899853ad 
{margin-bottom:10px;padding:0 0;}#yiv4606899853 #yiv4606899853actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4606899853 
#yiv4606899853activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4606899853
 #yiv4606899853activity span {font-weight:700;}#yiv4606899853 
#yiv4606899853activity span:first-child 
{text-transform:uppercase;}#yiv4606899853 #yiv4606899853activity span a 
{color:#5085b6;text-decoration:none;}#yiv4606899853 #yiv4606899853activity span 
span {color:#ff7900;}#yiv4606899853 #yiv4606899853activity span 
.yiv4606899853underline {text-decoration:underline;}#yiv4606899853 
.yiv4606899853attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4606899853 .yiv4606899853attach div a 
{text-decoration:none;}#yiv4606899853 .yiv4606899853attach img 
{border:none;padding-right:5px;}#yiv4606899853 .yiv4606899853attach label 
{display:block;margin-bottom:5px;}#yiv4606899853 .yiv4606899853attach label a 
{text-decoration:none;}#yiv4606899853 blockquote {margin:0 0 0 
4px;}#yiv4606899853 .yiv4606899853bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4606899853 
.yiv4606899853bold a {text-decoration:none;}#yiv4606899853 dd.yiv4606899853last 
p a {font-family:Verdana;font-weight:700;}#yiv4606899853 dd.yiv4606899853last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4606899853 
dd.yiv4606899853last p span.yiv4606899853yshortcuts 
{margin-right:0;}#yiv4606899853 div.yiv4606899853attach-table div div a 
{text-decoration:none;}#yiv4606899853 div.yiv4606899853attach-table 
{width:400px;}#yiv4606899853 div.yiv4606899853file-title a, #yiv4606899853 
div.yiv4606899853file-title a:active, #yiv4606899853 
div.yiv4606899853file-title a:hover, #yiv4606899853 div.yiv4606899853file-title 
a:visited {text-decoration:none;}#yiv4606899853 div.yiv4606899853photo-title a, 
#yiv4606899853 div.yiv4606899853photo-title a:active, #yiv4606899853 
div.yiv4606899853photo-title a:hover, #yiv4606899853 
div.yiv4606899853photo-title a:visited {text-decoration:none;}#yiv4606899853 
div#yiv4606899853ygrp-mlmsg #yiv4606899853ygrp-msg p a 
span.yiv4606899853yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4606899853 
.yiv4606899853green {color:#628c2a;}#yiv4606899853 .yiv4606899853MsoNormal 
{margin:0 0 0 0;}#yiv4606899853 o {font-size:0;}#yiv4606899853 
#yiv4606899853photos div {float:left;width:72px;}#yiv4606899853 
#yiv4606899853photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4606899853 
#yiv4606899853photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4606899853
 #yiv4606899853reco-category {font-size:77%;}#yiv4606899853 
#yiv4606899853reco-desc {font-size:77%;}#yiv4606899853 .yiv4606899853replbq 
{margin:4px;}#yiv4606899853 #yiv4606899853ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv4606899853 #yiv4606899853ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4606899853 
#yiv4606899853ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4606899853 
#yiv4606899853ygrp-mlmsg select, #yiv4606899853 input, #yiv4606899853 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4606899853 
#yiv4606899853ygrp-mlmsg pre, #yiv4606899853 code {font:115% 
monospace;}#yiv4606899853 #yiv4606899853ygrp-mlmsg * 
{line-height:1.22em;}#yiv4606899853 #yiv4606899853ygrp-mlmsg #yiv4606899853logo 
{padding-bottom:10px;}#yiv4606899853 #yiv4606899853ygrp-msg p a 
{font-family:Verdana;}#yiv4606899853 #yiv4606899853ygrp-msg 
p#yiv4606899853attach-count span {color:#1E66AE;font-weight:700;}#yiv4606899853 
#yiv4606899853ygrp-reco #yiv4606899853reco-head 
{color:#ff7900;font-weight:700;}#yiv4606899853 #yiv4606899853ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv4606899853 #yiv4606899853ygrp-sponsor 
#yiv4606899853ov li a {font-size:130%;text-decoration:none;}#yiv4606899853 
#yiv4606899853ygrp-sponsor #yiv4606899853ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4606899853 
#yiv4606899853ygrp-sponsor #yiv4606899853ov ul {margin:0;padding:0 0 0 
8px;}#yiv4606899853 #yiv4606899853ygrp-text 
{font-family:Georgia;}#yiv4606899853 #yiv4606899853ygrp-text p {margin:0 0 1em 
0;}#yiv4606899853 #yiv4606899853ygrp-text tt {font-size:120%;}#yiv4606899853 
#yiv4606899853ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv4606899853   

Attachment: Mencari Nilai dengan Criteria.xlsx
Description: MS-Excel 2007 spreadsheet

  • [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