{"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":"2025-09-15T17:15:58","modified_gmt":"2025-09-15T08:15:58","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":"

This post is a corrected post after AI explains the code included in the book “Google Apps Script 101: Building Work Automation For Free”<\/a>. Added a strikethrough<\/s> when editing what AI has written, and added color<\/span> when edited by author<\/p>\n

Table of Contents<\/h2>\n
    \n
  1. Summary<\/a><\/li>\n
  2. Code<\/a><\/li>\n
  3. Code Explanation<\/a><\/li>\n
  4. Example<\/a><\/li>\n
  5. AI Prompt<\/a><\/li>\n<\/ol>\n

    Summary<\/h2>\n

    In this blog post, we will learn how to filter data based on age in Apps Script. We will use the filter()<\/code> function to extract rows from a spreadsheet that meet a specific age criterion.<\/p>\n

    Code<\/h2>\n
    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 => row[2] >= 8)\n  Logger.log(dataFilter)\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code defines a function named filterAge<\/code>. It starts by getting the active spreadsheet and retrieving a specific sheet named ‘\uc2dc\ud2b86’ using getSheetByName()<\/code>.<\/p>\n
    The getDataRange()<\/code> method is used to get the range of data in the sheet, and getValues()<\/code> is used to retrieve all the values from that range.<\/p>\n
    Next, the filter()<\/code> function is applied to the data array to create a new array, 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
    Finally, the filtered data is logged using Logger.log()<\/code>.<\/p>\n
    Example<\/h2>\n
    Let’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
    Using the filterAge()<\/code> function, we can easily achieve this:<\/s><\/p>\n
    This will log an array of rows that meet the age criterion to the Apps Script Logger.<\/s><\/p>\n
    Suppose you have a Google Sheet with a column named ‘Sheet6’. We want to filter the data so that it only includes rows where the age is 8 or older.<\/span><\/p>\n\n\n\n\n\n\n\n
    Column A<\/th>\nColumn B<\/th>\nColumn C<\/th>\n<\/tr>\n
    Type<\/td>\nName<\/td>\nAge<\/td>\n<\/tr>\n
    cat<\/td>\nPong<\/td>\n5<\/td>\n<\/tr>\n
    Puppy<\/td>\nTami<\/td>\n10<\/td>\n<\/tr>\n
    cat<\/td>\nping<\/td>\n10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    When the filterAge()<\/code> function is run, the filtered data is logged to the Apps Script logger.<\/span><\/p>\n\n\n\n\n
    Puppy<\/td>\nTami<\/td>\n10<\/td>\n<\/tr>\n
    cat<\/td>\nping<\/td>\n10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    AI Prompt<\/h2>\n
    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 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
    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":"
    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":{"_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":[5,118],"tags":[512,69,25,7],"class_list":["post-15597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-filter","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"_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}]}}