How to Use Date Criteria in Filter Function in Google Sheets

Learn to apply date criteria in filter function in Google Sheets. Filter is not a new term to many spreadsheet users. But Filter function...

Google Sheets SWITCH Formula How to and Compare It with IF...

Learn the use of Google Sheets SWITCH formula. Once learned, you can use this Logical Function to easily replace several IF or IFS functions....

How to Find Duplicates in Google Sheets Using Dynamic Formula

You can use formula to find duplicates in Google Sheets. There are three different approaches in finding duplicate words, text or rows in Google...

LEN Function in Google Sheets and Practical Use of It

Honestly, I am very rarely using Google Sheets LEN function. Still at one point, I find it very tricky. I normally use LEN function...

Vlookup to Find Nth Occurrence in Google Sheets [Dynamic Lookup]

If you are searching for a way to perform dynamic lookup in Google Sheets, you are on the right page. Here is my complete...

How to Use SMALL Formula in Google Sheets [Basic and Advanced...

Google Sheets SMALL function seems so simple at first look. But do you know you can use this simple formula in complex calculations that...

How to Use Google Sheets TRUNC Function [Difference with INT and...

Google Sheets TRUNC function is all about shortening the number of decimal places. Though you can achieve the same by using Google Sheets Round...

How to use Round Functions in Google Sheets [ROUND, ROUNDUP, ROUNDDOWN]

It's always a better idea to keep the numbers simple. So here comes the importance of round functions in Google Sheets. There are certain rules...

Google Sheets Function Guide [Quickly Learn All Popular Functions]

A streamlined Google Sheets function guide that can make you a pro in Google Sheets' Application use. Pick one function from the list, learn...

Google Sheets IFERROR Function – Usage and Examples

Google Sheets IFERROR function is a common spreadsheet function to clean up formula results. It's so simple to use and a must to know...

Social

727FansLike
109FollowersFollow
307FollowersFollow