Index Match – Better Alternative to Vlookup and Hlookup in Google...

Index Match is a better alternative to Vlookup and Hlookup in Google Sheets. Don't mistake that Index Match is one simple function. It's INDEX...

How to Use IF Function in Google Sheets – Advanced Tips

Much have been talked about the popular IF Function in Google Sheets here on Info Inspired. Should I write a separate tutorial for it again?...

How to Pick a Random Name from a Long List in...

Ever wondered how to pick a random name from a long list in Google Sheets? With the help of this tutorial anyone can make a...

How to Use Google Sheets Index Function – Advanced Tips

Index, Match and Offset are three similar functions in Google Sheets. Also when you combine Index and Match functions, it can behave like Vlookup...

How to Use Match Function in Google Sheets – Examples

When you independently use MATCH function in Google Sheets , it has only one role to do. It's to return the relative position of...

How to Use RAND and RANDBETWEEN Functions in Google Sheets

There are two random number generator functions in Google Sheets. They are RAND and RANDBETEEEN volatile Google Sheet functions. This time we can learn...

Frequency of Recalculation of Google Sheets NOW, TODAY, RAND, RANDBETWEEN Functions

In this quick tutorial, I will explain you one of the important spreadsheet settings in Google Sheets. We can learn how to change the frequency...

How to Use Curly Brackets to Create Arrays in Google Sheets

In Google Sheets, one can use Curly Brackets or Curly Braces to create Arrays. Array is none other than table. An array consists rows and...

How to Use RANK Function in Google Sheets – Example Formula

Just like MODE function, RANK is another useful statistical function in Google Sheets. I will tell you how to use RANK Function in Google...

How to Check a Single Value in a Range of Cells...

In Google Sheets, you can easily check a single value in a range of cells using function. This time I am detailing this tips...

Social

727FansLike
109FollowersFollow
307FollowersFollow