Mohon maaf sebelumnya, karena infonya tidak detail, pada intinya saya hendak mencari jumlah dari Header D1 Ke Header J1 yang jumlahnya minimal >=95..
Misalkan :
ADI => sum (D2: J2) yang >= 95 , ternyata ada di Header 0.03 (E1)
Pada Intinya mencari jumlah maximum >=95 ada di header mana.
Pada Jumat, 24 Januari 2020 15.05.51 WIB, Idrus, Adi
<[email protected]> menulis:
#yiv3282922369 -- filtered {}#yiv3282922369 filtered {}#yiv3282922369 filtered
{}#yiv3282922369 filtered {}#yiv3282922369 filtered {}#yiv3282922369 filtered
{}#yiv3282922369 p.yiv3282922369MsoNormal, #yiv3282922369
li.yiv3282922369MsoNormal, #yiv3282922369 div.yiv3282922369MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv3282922369
a:link, #yiv3282922369 span.yiv3282922369MsoHyperlink
{color:blue;text-decoration:underline;}#yiv3282922369 a:visited, #yiv3282922369
span.yiv3282922369MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv3282922369 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv3282922369
code {}#yiv3282922369 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;}#yiv3282922369 tt
{}#yiv3282922369 span.yiv3282922369HTMLPreformattedChar
{font-family:Consolas;}#yiv3282922369 p.yiv3282922369attach, #yiv3282922369
li.yiv3282922369attach, #yiv3282922369 div.yiv3282922369attach
{margin-right:0in;margin-left:0in;font-size:9.0pt;}#yiv3282922369
p.yiv3282922369bold, #yiv3282922369 li.yiv3282922369bold, #yiv3282922369
div.yiv3282922369bold
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-weight:bold;}#yiv3282922369
p.yiv3282922369green, #yiv3282922369 li.yiv3282922369green, #yiv3282922369
div.yiv3282922369green
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;color:#628C2A;}#yiv3282922369
p.yiv3282922369replbq, #yiv3282922369 li.yiv3282922369replbq, #yiv3282922369
div.yiv3282922369replbq
{margin:3.0pt;font-size:12.0pt;font-family:New;}#yiv3282922369
p.yiv3282922369ad, #yiv3282922369 li.yiv3282922369ad, #yiv3282922369
div.yiv3282922369ad
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv3282922369
p.yiv3282922369underline, #yiv3282922369 li.yiv3282922369underline,
#yiv3282922369 div.yiv3282922369underline
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv3282922369
span.yiv3282922369yshortcuts {}#yiv3282922369 p.yiv3282922369ad1,
#yiv3282922369 li..yiv3282922369ad1, #yiv3282922369 div.yiv3282922369ad1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv3282922369
p.yiv3282922369ad2, #yiv3282922369 li.yiv3282922369ad2, #yiv3282922369
div.yiv3282922369ad2
{margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv3282922369
p.yiv3282922369underline1, #yiv3282922369 li.yiv3282922369underline1,
#yiv3282922369 div.yiv3282922369underline1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;text-decoration:underline;}#yiv3282922369
span.yiv3282922369yshortcuts1 {font-weight:bold;}#yiv3282922369
span.yiv3282922369yshortcuts2 {font-weight:normal;}#yiv3282922369
span.yiv3282922369EmailStyle34 {color:#1F497D;}#yiv3282922369
.yiv3282922369MsoChpDefault {font-size:10.0pt;}#yiv3282922369 filtered
{}#yiv3282922369 div.yiv3282922369WordSection1 {}#yiv3282922369 filtered
{}#yiv3282922369 filtered {}#yiv3282922369 filtered {}#yiv3282922369 filtered
{}#yiv3282922369 filtered {}#yiv3282922369 filtered {}#yiv3282922369 filtered
{}#yiv3282922369 filtered {}#yiv3282922369 filtered {}#yiv3282922369 filtered
{}#yiv3282922369 ol {margin-bottom:0in;}#yiv3282922369 ul
{margin-bottom:0in;}#yiv3282922369
Ini maksudnya gimana ya bu? bisa diperjelas kah
From: [email protected] [mailto:[email protected]]
Sent: Friday, January 24, 2020 10:35 AM
To: [email protected]
Subject: [SPAM] ]] XL-mania [[ Menentukan Nilai Maximum [1 Attachment]
Sahabat XL Mania,
saya ada kendala mengenai penggunaan nilai maximum di XL, mohon di bantu
bagamana cara menetukan nilai Maximum, jika menggunakan IF(sum) akan ada
limited di kolom 11
terimakasih atas bantuannya
NilaiMax_95_r.xlsx
Description: MS-Excel 2007 spreadsheet
