Home Blog Page 3

A Custom Formula to Use for Start Date and End Date Based Calculations in Google Sheets

This is the first time I took lots of time to properly title a post. Still I'm unsure whether I've justified to the tutorial below. Also I can't call it a tutorial. I am going to provide you a Custom Formula to Use for Start Date and End Date Based Calculations in Google Sheets. What type of calculations? You can use...

40 Rare Kathasaritsagara Quotes [Indian Fairy Tales and Folk Tales Quotes]

We at Info Inspired have compiled forty rare Kathasaritsagara quotes. I think it's the first attempt on the web in it kinds to introduce some of the jewels from Kathasaritsagara,  the collection of Indian fairy tales, folk tales and Indian legends. Kathasaritsagara takes you through captivating fairy tales of Kings, Queens, ancient kingdoms, Hindu myths etc. Kathasaritsagara is said to be derived...

Fifteen Inspirational Quotes from Poems for Your Daily Motivation

Inspirational quotes from poems are a rare collection of 15 powerful inspirational and motivational quotes of famous poets from their famous poems. I hope, these quotes can lift up your fading hopes in life. You always need inspiration in your life to achieve your dream goals. So let's begin. Inspirational Quotes from Poems "If you can't be a pine on the...

How to Use AND,OR with Google Sheets Filter Function – ADVANCED Use

I am going to share you a very rare and tricky use of AND,OR with Google Sheets Filter Function. I'm sure it's totally new to you. What else! I am going to compare AND,OR,FILTER Formula with AND,OR,IF Logical Formula. We have already detailed tutorials on Google Sheets FILTER, AND, OR, IF Functions. Now here I will explain you how to...

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 may be new. In Google Sheets, in addition to the popular Filter Command, there is a Filter function. I always think Functions have an edge over Commands. Filter function is an example to this. Here...

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

Learn the use of Google Sheets SWITCH formula. Once learned, you can use this Logical Function to easily replace several IF or IFS functions. I have detailed how to use SWITCH function below and also compared it with IF, IFS and Nested IF. We are obsessed with IF and IFS. So time to limit the use of them. Show your...

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 Sheets using Formula. I will explain you all the three different approaches with examples below. The Three Approaches to Find Duplicates in Google Sheets Using Formula Using UNIQUE Function. With the Help of FILTER Function. Using...

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 in Google Sheets to control the ARRAYFORMULA expansion to adjoining cells. I will come to that later. How to Use LEN Function in Google Sheets LEN function returns the length of a string. That is the whole...

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 solution to find Nth Occurrence in Google Sheets, the unsolved puzzle! What more! You can use this formula on your own sheets without any issue. No scripts used to find the Nth occurrence. Only the Google...

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

Google Sheets SMALL function seems so simple at first look. But do you know you can use this simple formula in complex calculations that even for dynamic VLOOKUP. So, this time I am going to explain you how to use SMALL Formula for basic as well as complex calculations in Google Sheets. Purpose of SMALL Formula in Google Spreadsheets Syntax: SMALL(data, n) Where; data...

727Fans
109Followers
307Followers