{"id":15597,"date":"2023-08-16T09:00:00","date_gmt":"2023-08-16T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/"},"modified":"2026-08-21T16:52:38","modified_gmt":"2026-08-21T07:52:38","slug":"filtering-data-by-age-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/","title":{"rendered":"Filtering Data by Number in Apps Script"},"content":{"rendered":"<p>This post is a corrected post after AI explains the code included in the book <a title=\"\" href=\"https:\/\/www.autooffice.io\/content\/ebizbooks-apps-script\" target=\"_blank\" rel=\"noopener\">&#8220;Google Apps Script 101: Building Work Automation For Free&#8221;<\/a>. Added a <s>strikethrough<\/s> when editing what AI has written, and added <span style=\"color: #ff3366;\">color<\/span> when edited by author<\/p>\n<h2>Table of Contents<\/h2>\n<ol>\n<li><a href=\"#summary\">Summary<\/a><\/li>\n<li><a href=\"#code\">Code<\/a><\/li>\n<li><a href=\"#explanation\">Code Explanation<\/a><\/li>\n<li><a href=\"#example\">Example<\/a><\/li>\n<li><a href=\"#ai-prompt\">AI Prompt<\/a><\/li>\n<\/ol>\n<h2 id=\"summary\">Summary<\/h2>\n<p>In this blog post, we will learn how to filter data based on age in Apps Script. We will use the <code>filter()<\/code> function to extract rows from a spreadsheet that meet a specific age criterion.<\/p>\n<h2 id=\"code\">Code<\/h2>\n<pre><code>function filterAge() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET6 = SS.getSheetByName('\uc2dc\ud2b86')\n\n  const data = T_SHEET6.getDataRange().getValues()\n  let dataFilter = data.filter(row =&gt; row[2] &gt;= 8)\n  Logger.log(dataFilter)\n}<\/code><\/pre>\n<h2 id=\"explanation\">Code Explanation<\/h2>\n<p>The code defines a function named <code>filterAge<\/code>. It starts by getting the active spreadsheet and retrieving a specific sheet named &#8216;\uc2dc\ud2b86&#8217; using <code>getSheetByName()<\/code>.<\/p>\n<p>The <code>getDataRange()<\/code> method is used to get the range of data in the sheet, and <code>getValues()<\/code> is used to retrieve all the values from that range.<\/p>\n<p>Next, the <code>filter()<\/code> function is applied to the data array to create a new array, <code>dataFilter<\/code>, that contains only the rows where the age in the third column (index 2) is greater than or equal to 8.<\/p>\n<p>Finally, the filtered data is logged using <code>Logger.log()<\/code>.<\/p>\n<h2 id=\"example\">Example<\/h2>\n<p><s>Let&#8217;s say we have a spreadsheet with student data, including their names, ages, and grades. We want to filter out all the students who are 8 years old or older.<\/s><\/p>\n<p><s>Using the <code>filterAge()<\/code> function, we can easily achieve this:<\/s><\/p>\n<p><s>This will log an array of rows that meet the age criterion to the Apps Script Logger.<\/s><\/p>\n<p><span style=\"color: #ff3366;\">Suppose you have a Google Sheet with a column named &#8216;Sheet6&#8217;. We want to filter the data so that it only includes rows where the age is 8 or older.<\/span><\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<th>Column A<\/th>\n<th>Column B<\/th>\n<th>Column C<\/th>\n<\/tr>\n<tr>\n<td>Type<\/td>\n<td>Name<\/td>\n<td>Age<\/td>\n<\/tr>\n<tr>\n<td>cat<\/td>\n<td>Pong<\/td>\n<td>5<\/td>\n<\/tr>\n<tr>\n<td>Puppy<\/td>\n<td>Tami<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>cat<\/td>\n<td>ping<\/td>\n<td>10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"color: #ff3366;\">When the <code>filterAge()<\/code> function is run, the filtered data is logged to the Apps Script logger.<\/span><\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>Puppy<\/td>\n<td>Tami<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>cat<\/td>\n<td>ping<\/td>\n<td>10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"ai-prompt\">AI Prompt<\/h2>\n<p><s>Write a function that filters data based on age. Retrieve the active spreadsheet and get a specific sheet by name. Get the data range and values from the sheet. Apply the <code>filter()<\/code> function to create a new array that contains only the rows where the age meets a specific criterion. Log the filtered data.<\/s><\/p>\n<p><span style=\"color: #ff3366;\">When an animal type is recorded in the first column, a name in the second column, and an age in the third column in a Google sheet, use filter to get the data of which animals are older than 8 years old. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.<\/p>\n","protected":false},"author":1,"featured_media":15616,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[118],"tags":[512,355,25,7],"class_list":["post-15597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apps-script","tag-ai-assisted","tag-apps-script","tag-filter","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.5","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc774\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uaca0\uc2b5\ub2c8\ub2e4. filter() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud2b9\uc815 \ub098\uc774 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ud589(row)\uc744 \ucd94\ucd9c\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"autooffice\"\/>\n\t<meta name=\"keywords\" content=\"ai assisted,apps script,filter,spreadsheet,\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Filtering Data by Number in Apps Script - Tech Blog of autooffice\" \/>\n\t\t<meta property=\"og:description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc774\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uaca0\uc2b5\ub2c8\ub2e4. filter() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud2b9\uc815 \ub098\uc774 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ud589(row)\uc744 \ucd94\ucd9c\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t\t<meta property=\"og:image:height\" content=\"210\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-08-16T00:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-08-21T07:52:38+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Filtering Data by Number in Apps Script - Tech Blog of autooffice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc774\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uaca0\uc2b5\ub2c8\ub2e4. filter() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud2b9\uc815 \ub098\uc774 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ud589(row)\uc744 \ucd94\ucd9c\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#blogposting\",\"name\":\"Filtering Data by Number in Apps Script - Tech Blog of autooffice\",\"headline\":\"Filtering Data by Number in Apps Script\",\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/filter-by-number.png\",\"width\":696,\"height\":400},\"datePublished\":\"2023-08-16T09:00:00+09:00\",\"dateModified\":\"2026-08-21T16:52:38+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#webpage\"},\"articleSection\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8, AI Assisted, Apps Script, FILTER, Spreadsheet\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apps-script\\\/#listItem\",\"name\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apps-script\\\/#listItem\",\"position\":2,\"name\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apps-script\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#listItem\",\"name\":\"Filtering Data by Number in Apps Script\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#listItem\",\"position\":3,\"name\":\"Filtering Data by Number in Apps Script\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apps-script\\\/#listItem\",\"name\":\"\\uc571\\uc2a4 \\uc2a4\\ud06c\\ub9bd\\ud2b8\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"telephone\":\"+821024904264\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-new2023.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#organizationLogo\",\"width\":1461,\"height\":250},\"image\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/\",\"name\":\"autooffice\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#webpage\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/\",\"name\":\"Filtering Data by Number in Apps Script - Tech Blog of autooffice\",\"description\":\"{:ko}\\uc774 \\ube14\\ub85c\\uadf8 \\ud3ec\\uc2a4\\ud2b8\\uc5d0\\uc11c\\ub294 Apps Script\\ub97c \\uc0ac\\uc6a9\\ud558\\uc5ec \\ub098\\uc774\\uc5d0 \\ub530\\ub77c \\ub370\\uc774\\ud130\\ub97c \\ud544\\ud130\\ub9c1\\ud558\\ub294 \\ubc29\\ubc95\\uc744 \\ubc30\\uc6b0\\uaca0\\uc2b5\\ub2c8\\ub2e4. filter() \\ud568\\uc218\\ub97c \\uc0ac\\uc6a9\\ud558\\uc5ec \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc5d0\\uc11c \\ud2b9\\uc815 \\ub098\\uc774 \\uae30\\uc900\\uc744 \\ucda9\\uc871\\ud558\\ub294 \\ud589(row)\\uc744 \\ucd94\\ucd9c\\ud569\\ub2c8\\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/filter-by-number.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#mainImage\",\"width\":696,\"height\":400},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2023\\\/08\\\/16\\\/filtering-data-by-age-in-apps-script\\\/#mainImage\"},\"datePublished\":\"2023-08-16T09:00:00+09:00\",\"dateModified\":\"2026-08-21T16:52:38+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"alternateName\":\"autooffice\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Filtering Data by Number in Apps Script - Tech Blog of autooffice","description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc774\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uaca0\uc2b5\ub2c8\ub2e4. filter() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud2b9\uc815 \ub098\uc774 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ud589(row)\uc744 \ucd94\ucd9c\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}","canonical_url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/","robots":"max-image-preview:large","keywords":"ai assisted,apps script,filter,spreadsheet,\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#blogposting","name":"Filtering Data by Number in Apps Script - Tech Blog of autooffice","headline":"Filtering Data by Number in Apps Script","author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/08\/filter-by-number.png","width":696,"height":400},"datePublished":"2023-08-16T09:00:00+09:00","dateModified":"2026-08-21T16:52:38+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#webpage"},"isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#webpage"},"articleSection":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8, AI Assisted, Apps Script, FILTER, Spreadsheet"},{"@type":"BreadcrumbList","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/#listItem","position":1,"name":"Home","item":"https:\/\/www.autooffice.co.kr\/en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/#listItem","name":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/#listItem","position":2,"name":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","item":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#listItem","name":"Filtering Data by Number in Apps Script"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#listItem","position":3,"name":"Filtering Data by Number in Apps Script","previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/#listItem","name":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8"}}]},{"@type":"Organization","@id":"https:\/\/www.autooffice.co.kr\/en\/#organization","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","url":"https:\/\/www.autooffice.co.kr\/en\/","telephone":"+821024904264","logo":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/logo-new2023.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#organizationLogo","width":1461,"height":250},"image":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/","name":"autooffice"},{"@type":"WebPage","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#webpage","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/","name":"Filtering Data by Number in Apps Script - Tech Blog of autooffice","description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc774\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uaca0\uc2b5\ub2c8\ub2e4. filter() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud2b9\uc815 \ub098\uc774 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ud589(row)\uc744 \ucd94\ucd9c\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#website"},"breadcrumb":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#breadcrumblist"},"author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"creator":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/08\/filter-by-number.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#mainImage","width":696,"height":400},"primaryImageOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/#mainImage"},"datePublished":"2023-08-16T09:00:00+09:00","dateModified":"2026-08-21T16:52:38+09:00"},{"@type":"WebSite","@id":"https:\/\/www.autooffice.co.kr\/en\/#website","url":"https:\/\/www.autooffice.co.kr\/en\/","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","alternateName":"autooffice","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","og:type":"article","og:title":"Filtering Data by Number in Apps Script - Tech Blog of autooffice","og:description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc774\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uaca0\uc2b5\ub2c8\ub2e4. filter() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud2b9\uc815 \ub098\uc774 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ud589(row)\uc744 \ucd94\ucd9c\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}","og:url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/","og:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:secure_url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:width":400,"og:image:height":210,"article:published_time":"2023-08-16T00:00:00+00:00","article:modified_time":"2026-08-21T07:52:38+00:00","twitter:card":"summary_large_image","twitter:title":"Filtering Data by Number in Apps Script - Tech Blog of autooffice","twitter:description":"{:ko}\uc774 \ube14\ub85c\uadf8 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc774\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uaca0\uc2b5\ub2c8\ub2e4. filter() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud2b9\uc815 \ub098\uc774 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ud589(row)\uc744 \ucd94\ucd9c\ud569\ub2c8\ub2e4.{:}{:en}In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter() function to extract rows from a spreadsheet that meet a specific age criterion.{:}","twitter:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png"},"aioseo_meta_data":{"post_id":"15597","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","score":56},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2023-08-16 05:14:09","updated":"2026-08-21 08:49:38","seo_analyzer_scan_date":null,"focus_keyword":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/\" title=\"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\">\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tFiltering Data by Number in Apps Script\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.autooffice.co.kr\/en\/"},{"label":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apps-script\/"},{"label":"Filtering Data by Number in Apps Script","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-by-age-in-apps-script\/"}],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=15597"}],"version-history":[{"count":7,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15597\/revisions"}],"predecessor-version":[{"id":17161,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15597\/revisions\/17161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15616"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}