{"id":1457,"date":"2015-03-04T17:08:42","date_gmt":"2015-03-04T09:08:42","guid":{"rendered":"https:\/\/cowmanchiang.me\/wp\/?p=1457"},"modified":"2023-10-31T15:43:49","modified_gmt":"2023-10-31T07:43:49","slug":"excel-find-the-latest-value","status":"publish","type":"post","link":"https:\/\/cowmanchiang.me\/wp\/?p=1457","title":{"rendered":"[Excel] Find the latest value"},"content":{"rendered":"<p><a href=\"http:\/\/192.168.0.89\/wp\/wp-content\/uploads\/2015\/03\/20150304.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/192.168.0.89\/wp\/wp-content\/uploads\/2015\/03\/20150304.png\" alt=\"20150304\" width=\"913\" height=\"128\" class=\"aligncenter size-full wp-image-1458\" srcset=\"https:\/\/cowmanchiang.me\/wp\/wp-content\/uploads\/2015\/03\/20150304.png 913w, https:\/\/cowmanchiang.me\/wp\/wp-content\/uploads\/2015\/03\/20150304-300x42.png 300w\" sizes=\"auto, (max-width: 913px) 100vw, 913px\" \/><\/a> If we want use excel to get the value F.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"\">F = A * B * C * D * E<\/pre>\n<p>The common method is using the upper mathematical formulas. But if we adjust the columns, we may get the wrong value because there are some exceptions in the reference columns. So if we can use E to find the location of A or B, this problems are not exit. If E&#8217;s location is W7.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"\">W7 = LOOKUP(2,1\/($H$5:$H7&lt;&gt;&quot;&quot;),$H$5:$H7) * LOOKUP(2,1\/($M$5:$M7&lt;&gt;&quot;&quot;),$M$5:$M7),$P7,S7) * P7 * R7<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If we want use excel to get the value F. F = A * B * C * D * E The common method is using the upper mathematical formulas. But if we adjust the columns, we may get the &hellip; <a href=\"https:\/\/cowmanchiang.me\/wp\/?p=1457\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[94],"tags":[],"class_list":["post-1457","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1457"}],"version-history":[{"count":1,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1457\/revisions"}],"predecessor-version":[{"id":1927,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1457\/revisions\/1927"}],"wp:attachment":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}