Let’s say you have a Google Sheet with Multi Line text like: And you want to count how many times each phrase is mentioned or the most popular terms. keyword count Jquery 569 Google Tag Manager 438 Google Font Api … Continued
Although this is fairly easy to do, I ran into an issue and wanted to share some tips. Let’s say you want to return the matching text based on an existing list. In my case, I wanted to return the … Continued
If doing an IMPORTRANGE function in Google Sheets and you get the “You don’t have permissions to access that sheet.” error follow these steps: First make sure the sheet you are importing is NOT the XLSX version for Office Compatibility. … Continued
Google Sheets QUERY Tips
This was driving me insane for the longest time. Its really easy to hide the grand totals in Excel but how to do it in Google Sheets? As I was trying to come up with creative solutions using custom formulas, … Continued