Here’s a question from Dorothy: I am using Google Sheets and trying to use a Pivot table to group my data according to the week number. For some reason, that is not possible, although i see many other useful grouping options such as day of the week, day of the month, year-month etc’/ Any hints … Read more
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
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
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
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
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
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
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
Here’s a question from Randy: “I have a pretty long Google Sheets worksheet and need to be able to search for specific words in one of the columns. Seems that Sheets has somewhat different functions than Excel to find text in cells. Can you provide a simple example of how would you go about solving … Read more