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
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 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