How to Highlight Adjacent Duplicates in Google Sheets
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)
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
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
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
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
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...