How to count cells with specific text in Google Sheets?

Here’s a question from Merlin: I work for a food delivery service need to do some analysis and validation on a large data set that requires me to count all deliveries that were not timely delivered during 2023. Each delivery is represented by a single row in our database. My question is how can i … Read more

How to lowercase cell text in Google Sheets?

Here’s a question from Larry: I have a bunch of manually entered data that i need to validate and normalize it for then sending it over to IT so that they can import it to a customer database (built onMySQL) that our company uses for digital marketing. Part of my work is ensuring consistenct data … Read more

How to find if text exists in other column in Google Sheets?

To check whether text in one column exists in other column you can use the following formula: Check for text in another sheet or column Step #1: Prepare your data Gather your data in a Google Sheets worksheet and identify the lookup range (could be one or more columns located in your spreadsheet or another … Read more

How to plot a column chart in Google Sheets?

Here’s a question from Alvaro: I need to create to create a bar chart off some data that IT has pulled from a database into a Google Sheets spreadsheet. Any ideas on whether i can use Google Sheets in order to create a professional looking chart that i can then export to a slide? Create … Read more

How to combine two columns text in Google Sheets?

Use the following formula to concatenate two cells in Google Sheets worksheet columns: Or with a separator: Concatenate two or more columns in Google Sheets Step # 1: Prepare your worksheet Identify two or more columns that you would like to merge in your Google Sheets spreadsheet. In our example, we define two columns that … Read more

How to find if a column cell is empty in Google Sheets?

Here’s a question from Donnie: I manage a large Google Sheets spreadsheet that lists the software that should be installed in each of our employees’ computer. All systems should have the same software installed. Every time i install a program i update the spreadsheet. I would like to write a simple formula that will manage … Read more

Compare date time to today in Google Sheets

Here’s a question from Andrea: Quick question here, new Google Sheets user: how do i subtract dates in Google Sheets – i need to calculate the date difference between two date values: today and two project milestones in the future. I need to calculate the result in both calendar dates and working days – Any … Read more