{"id":1758,"date":"2022-08-08T09:37:00","date_gmt":"2022-08-08T14:37:00","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1758"},"modified":"2022-08-08T09:37:00","modified_gmt":"2022-08-08T14:37:00","slug":"return-12-values-in-one-number","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1758","title":{"rendered":"Return 12 values in one number"},"content":{"rendered":"\n<p>A technic I loved using, return list of items (up to 12 items now) in ONE number.<\/p>\n\n\n\n<p>Let us say you have list of 12 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for awhile in my archive. I called it 12Return4095<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>The main concept is set of formulas to do that, here we are using Excel functions only to do so.<\/p>\n\n\n\n<p>Example shows how formulas can extract list of items based on one number user enter in a cell. <\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/12Returns4095.jpg\"><img decoding=\"async\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/12Returns4095.jpg\" alt=\"\" class=\"wp-image-1759\"\/><\/a><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO65N2yDIQ0PdLlWEzJg?e=qiqb5X\" style=\"border-radius:4px\">Excel Online<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/12Returns4095.xlsx\" style=\"border-radius:4px\">Download<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=1758\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Return 12 values in one number&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1759,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68,3,80,35,38,41,6,56],"tags":[92,147,162,191],"class_list":["post-1758","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-and","category-formulas","category-if","category-logical","category-math-and-trig","category-min","category-standard_functions","category-sum","tag-and","tag-if","tag-min","tag-sum"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1758"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1758\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1759"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}