{"id":64900,"date":"2026-07-10T13:05:02","date_gmt":"2026-07-10T12:05:02","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=64900"},"modified":"2026-07-10T13:05:02","modified_gmt":"2026-07-10T12:05:02","slug":"lambda-i-built-my-own-excel-function-without-touching-vba-and-now-i-use-it-daily","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/lambda-i-built-my-own-excel-function-without-touching-vba-and-now-i-use-it-daily\/","title":{"rendered":"LAMBDA: I built my own Excel function without touching VBA, and now I use it daily"},"content":{"rendered":"<p>I built my own Excel function without touching VBA, and now I use it daily<br \/>\n<a href=\"https:\/\/www.makeuseof.com\/built-my-own-excel-function-without-touching-vba\/\" rel=\"nofollow\">https:\/\/www.makeuseof.com\/built-my-own-excel-function-without-touching-vba\/<\/a><\/p>\n<ul>\n<li>I kept rebuilding the same formula until Excel let me name it<br \/>\nLAMBDA turns a formula you lean on into a function you can call by name<\/li>\n<li>I built my custom function inside the Name Manager<br \/>\nThe whole thing took one dialog box and zero lines of code<\/li>\n<li>The functions I actually reach for every day<br \/>\nTwo that earned a permanent spot in my workbooks<\/li>\n<li>LAMBDA isn&#8217;t always the right call<br \/>\nWhen a plain formula or an actual macro still wins<\/li>\n<li>Where I&#8217;m taking my homemade functions next<br \/>\nCustom functions get more useful the more you stack them<\/li>\n<\/ul>\n<p>LAMBDA: The ultimate Excel worksheet function &#8211; Microsoft Research<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"Sy3tet0EtZ\"><p><a href=\"https:\/\/www.microsoft.com\/en-us\/research\/blog\/lambda-the-ultimatae-excel-worksheet-function\/\">LAMBDA: The ultimate Excel worksheet function<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cLAMBDA: The ultimate Excel worksheet function\u201d \u2014 Microsoft Research\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/blog\/lambda-the-ultimatae-excel-worksheet-function\/embed\/#?secret=EzalJen4j4#?secret=Sy3tet0EtZ\" data-secret=\"Sy3tet0EtZ\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>LAMBDA function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/functions\/lambda-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/functions\/lambda-function<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I built my own Excel function without touching VBA, and now I use it daily https:\/\/www.makeuseof.com\/built-my-own-excel-function-without-touching-vba\/ I kept rebuilding the same formula until Excel let me name it LAMBDA turns a formula you lean on into a function you can call by name I built my custom function inside the<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":1,"footnotes":""},"categories":[54,375],"tags":[],"class_list":["post-64900","post","type-post","status-publish","format-standard","hentry","category-excel","category-excel-office-2010"],"publishpress_future_action":{"enabled":false,"date":"2026-07-20 09:29:45","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=64900"}],"version-history":[{"count":1,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64900\/revisions"}],"predecessor-version":[{"id":64901,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64900\/revisions\/64901"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=64900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=64900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=64900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}