{"id":10537,"date":"2021-12-06T01:54:54","date_gmt":"2021-12-06T01:54:54","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=10537"},"modified":"2021-12-06T01:55:25","modified_gmt":"2021-12-06T01:55:25","slug":"find-top-3-values-and-return-names","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/find-top-3-values-and-return-names\/11798.html","title":{"rendered":"Find Top 3 Values And Return Names"},"content":{"rendered":"<p>Hi,<\/p>\n<p>It&#8217;s been a while since my last post but now I again need help. (i&#8217;m a hopeless wretch)<\/p>\n<p>What I have is a data of 2 columns. Col A contains names and Col B contains numbers. There are no duplicate names. What I am trying to do is in Cell D1, return the names from column A who got the top 3 scores shown in column B.<\/p>\n<p>To explain further, Is it possible to automatically look at the list under column B, get the top 3 highest numbers, then return the names in their row, under column A.<\/p>\n<p>I appreciate the help in advance.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":4},"question-category":[53],"question_tags":[],"class_list":["post-10537","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/10537","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=10537"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=10537"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=10537"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=10537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}