Learn how to search and find all values in an entire Google Sheet spreadsheet, in a specific sheet tab or in a range with Apps Script.
Handy little snippet from Scott Donald on using the Google Apps Script
TextFinder class to find all the occurrences of matching text in a Google Sheet. The bit I particularly liked in this solution was how Scott used a
.map method to return an object array of cell hits including A1 notation:
Follow the source link for more information including a video tutorial.
Source: Find All Values in Google Sheets with Apps Script – Yagisanatode
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
safari cannot open the page because too many redirects occurred
Seems fine just now, might have been a temporary issue?