{"id":382,"date":"2023-09-30T23:33:33","date_gmt":"2023-10-01T03:33:33","guid":{"rendered":"https:\/\/nikasoftware.com\/?p=382"},"modified":"2023-10-08T06:50:52","modified_gmt":"2023-10-08T05:50:52","slug":"take-formula-in-excel","status":"publish","type":"post","link":"https:\/\/nikasoftware.com\/index.php\/2023\/09\/30\/take-formula-in-excel\/","title":{"rendered":"Take Formula in Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Use of Take Formula.<\/h2>\n\n\n\n<p>Take formula is used for data retrieval by given rows and columns that&#8217;s we want to take. <\/p>\n\n\n\n<p>In other words, Return a specified numbers of contiguous rows and columns from the start or end of the array.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax.<\/h2>\n\n\n\n<p>=TAKE(array, rows,[columns])<\/p>\n\n\n\n<p>The TAKE function syntax has the following arguments:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>array<\/strong>:&nbsp;&nbsp; The array from which to take rows or columns.<\/li>\n\n\n\n<li><strong>rows<\/strong>:&nbsp;&nbsp;&nbsp; The number of rows to take. A negative value takes from the end of the array.<\/li>\n\n\n\n<li><strong>columns<\/strong>:&nbsp; The number of columns to take. A negative value takes from the end of the array.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Errors.<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Excel returns a #CALC! error to indicate an empty array when either rows or columns is 0.&nbsp;<\/li>\n\n\n\n<li>Excel returns a #NUM when array is too large.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Let&#8217;s see an Example 1.<\/h2>\n\n\n\n<p>Here we have some data in Excel. You can download it from <a href=\"https:\/\/app.digiboxx.com\/share\/9ebf52fb4cf4712f\" target=\"_blank\" rel=\"noopener nofollow sponsored ugc\" title=\"\">CLICK HERE<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikasoftware.com\/wp-content\/uploads\/2023\/09\/take-2-1024x829.png\" alt=\"\" class=\"wp-image-386\"\/><\/figure>\n\n\n\n<p>Returns the first three rows from the array in range A1:E10.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formulas<\/strong>.<\/h2>\n\n\n\n<p>=TAKE(A1:E10,3)    like see in the figure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikasoftware.com\/wp-content\/uploads\/2023\/09\/take-3-1024x809.png\" alt=\"\" class=\"wp-image-387\"\/><\/figure>\n\n\n\n<p>Result is&#8230;..<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikasoftware.com\/wp-content\/uploads\/2023\/09\/take-4-1024x556.png\" alt=\"\" class=\"wp-image-388\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Example 2:<\/h2>\n\n\n\n<p>Returns the first three columns from the array in range A1:E10.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formulas<\/strong>.<\/h2>\n\n\n\n<p>=TAKE(A1:E10,,3) and result will be there like in the figure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikasoftware.com\/wp-content\/uploads\/2023\/09\/take-5-1024x638.png\" alt=\"\" class=\"wp-image-389\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Example 3:<\/h2>\n\n\n\n<p>Returns the last three rows from the array in range A1:E10.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formulas<\/strong>.<\/h2>\n\n\n\n<p>=TAKE(A1:E10,-3) and result will be there like in the figure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikasoftware.com\/wp-content\/uploads\/2023\/09\/take-6-1024x672.png\" alt=\"\" class=\"wp-image-393\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Example 4:<\/h2>\n\n\n\n<p>Returns the last three columns from the array in range A1:E10.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formulas<\/strong>.<\/h2>\n\n\n\n<p>=TAKE(A1:E10,,-3) and result will be there like in the figure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikasoftware.com\/wp-content\/uploads\/2023\/09\/take-7-1024x751.png\" alt=\"\" class=\"wp-image-395\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Example 5:<\/h2>\n\n\n\n<p>Returns the first three rows and first two columns from the array in range A1:E10.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formulas<\/strong>.<\/h2>\n\n\n\n<p>=TAKE(A1:E10,3,2) and result will be there like in the figure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikasoftware.com\/wp-content\/uploads\/2023\/09\/take-8-1024x820.png\" alt=\"\" class=\"wp-image-397\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use of Take Formula. Take formula is used for data retrieval by given rows and columns that&#8217;s we want to take. In other words, Return a specified numbers of contiguous rows and columns from the start or end of the array. Syntax. =TAKE(array, rows,[columns]) The TAKE function syntax has the following arguments: Errors. Let&#8217;s see [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":"[]"},"categories":[24],"tags":[],"class_list":["post-382","post","type-post","status-publish","format-standard","hentry","category-ms-excel-tips-and-tricks"],"_links":{"self":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/comments?post=382"}],"version-history":[{"count":2,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/382\/revisions"}],"predecessor-version":[{"id":602,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/382\/revisions\/602"}],"wp:attachment":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/media?parent=382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/categories?post=382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/tags?post=382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}