Sum Each Unique Cell And Show Total Only On The First Or Last Instance Of Each Unique Cell
How do you find the sum of data according to each unique instance of values in a column and then insert the sum calculation for each unique cell at the …
Google Sheets
Google Sheets is an amazing online spreadsheet application to help perform all your spreadsheet needs. Besides saving your work automatically to the cloud and collaborating with other users together, Google Sheets also offers some expanded functionality by allowing you to code up in the Google App Script environment your specific requirements.
Set Conditional Format Based On Another Cell Value In Google Sheets
How can you create a conditional format in Google Sheets based on the value from another cell or column regardless of whether that cell is on the same sheet or …
“We’re sorry, a server error occurred while reading from storage. Error code NOT_FOUND.”
What do you do when you’re running a Google App Script and you encounter the following error in the Execution Log area? Check the libraries you have attached to your …
How To Clean And Format Phone Numbers In Google Sheets
If you’re working with data in Google Sheets you’ll soon come across a time when you will need to clean and format phone number data entries. To clean phone numbers …
How To Format Text Like “1st Jan 22” To A Date In Google Sheets
How do you format a cell that contains text like 1st Jan 2022 into a cell that Google Sheets can recognize as a date cell? There are certain types of …
How To Sort By Date In Google Sheets And What To Do When It Doesn’t Work
How do you sort a range containing dates in Google Sheets? Sorting a data set in columns or rows containing date data in Google Sheets can easily be done by …
How To Use The SWITCH Function In Google Sheets?
The SWITCH() function in Google Sheets is handy when dealing with multiple criteria based on a single result. The SWITCH() function takes at least 3 parameters, with the first parameter …
How To Separate Characters Into Cells In Excel
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to …
How To Get Rid Of E+(Number) In Excel
When using large numbers in Excel or any other spreadsheet application, such as Google Sheets, some cells may display a number in scientific notation like 9.991E+35. How do you get …
Why Does VLOOKUP Return #N/A When Value Exists? (Examples)
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
How To Use Multiple Ranges In QUERY Function: Google Sheets
The QUERY formula is a great way of being able to perform basic SQL-like commands on a data range. The signature of the QUERY formula is as follows: The first …
How To Unmerge Multiple Cells With One Click: Google Sheets
Merged cells are a great way to span content over multiple cells, and you can easily remove a single merged cell with one click by clicking on the merge cell …
How Do You Put Multiple Conditions In One Cell In Google Sheets?
There will come a time when using Google Sheets where you will be checking the value of a cell against multiple criteria, which one is the best to use? There …
Reverse Last Name & First Name With Comma Using One Formula: Google Sheets
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. …
IF Formula With Multiple Conditions: Google Sheets
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only …
How To Check If Cell Is Empty (Or Not): Google Sheets
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is …
What Is The Formula To Calculate Age?
Recently, I had an issue where I needed to calculate the age of a person at specific dates throughout the year. Using a Google Sheet, I thought I could simply …
How Do I COUNTIF Non-Blank Cells In Google Sheets?
The COUNTIF function in Google Sheets is a simple function which allows for the user to count a range of cells according to one specific filter. If more filters are …
How To Lock A Column In Google Sheets
Very similar to our previous article on how to make a header row in Google Sheets, in this article we’ll show how you can lock a column in Google Sheets. …
How To Make A Header Row In Google Sheets
I was recently working with a lot data on my Google Sheets spreadsheet and as I scrolled down the page the information from the top rows moved off and I …
