Spreadsheet

Best Google Spreadsheet (Sheets) formula examples: Query, Match, Lookup, Lambda, Database Functions, etc.

How to Highlight Adjacent Duplicates in Google Sheets

0
In this post, let's learn to highlight consecutive or adjacent duplicates in Google Sheets. The conditional formatting for the same is simple. Sometimes we may require...

How to Make a Vertical Line Graph in Google Sheets (Workaround)

0
In this tutorial, let's learn to make a vertical line graph in Google Sheets. I'm using a workaround method that only supports a single...

People Chip – Inserting and Converting Back to Email Address in Google Sheets

0
This post is about the People (Smart) Chip, the recent update to Google Sheets. We will discuss two points. How to insert People Chips and...

Find Next Biannual, Annual, Biennial, and Triennial Dates in Google Sheets

4
This tutorial will help you find the next biannual, annual, biennial, and triennial dates in Google Sheets. Sometimes you may want to find upcoming event...

OR in Multiple Columns in COUNTIFS in Google Sheets

0
In this tutorial, let me walk you through how to use the OR criterion in multiple columns in COUNTIFS in Google Sheets. In conditional count,...

Select All or a Specific Category in Multiple Columns in Filter in Google Sheets

0
This post explains how to select all or a specific category in multiple columns using the Filter function in Google Sheets. In Google Sheets, there...