How to Use Image Function in Google Sheets
This Google Sheets tutorial is about Image VLOOKUP and IMAGE function. I haven't shared so far how to use Image function in Google Sheets. You can learn that awesome tips in this tutorial and additionally you can learn here how to use Vlookup function to lookup images in Google Sheets. Earlier I've shared the tips to copy and paste images...
Practical Use of ISBLANK Function in Google Sheets
ISBLANK and LEN are two functions that I always find useful in some sort of Google Sheets calculations. The function LEN has already found a space on this page. Now learn here how to use ISBLANK function in Google Sheets. It's usefulness is more than what you think. ISBLANK is an info type function in Google Sheets. That means the...
Deduct Lunch Break Time From Total Hours in Google Sheets
Time calculation is important for preparing payroll, salary slip, hired equipment rental etc. With limited exposure to Time functions you can do this in Google Sheets. As an example learn here how to deduct lunch break time from total hours. To 'spice up' the formula, I'm using ArrayFormula together with time. See that below. I am sharing a common time...
How to Find All Lowest Price Items in Google Sheets
Using SORTN function it's quite easy to find all lowest price items in Google Sheets. just look at the screenshot below. When you have quotes from multiple vendors for different items, you may want to choose the lowest priced item from a list. In Google Sheets it's possible to extract all the lowest priced items with a tiny formula. Put that...
Remove Duplicate Rows and Keep The Rows With Max Value
I've a table in Google Sheets which is the price list of few fruits items. See that table below. In that table, as you can see, same items repeated multiple times but with different prices. How can I keep only the rows that contain the highest prices. In other words, In Google Sheets, I want to remove duplicate rows...
How to Use ROWS Function in Google Sheets
It's rare to see people using functions like ROWS and COLUMNS in Google Sheets. Just like the function ROW, the function ROWS has also plenty of use. So first learn how to use ROWS function in Google Sheets. Then I'll take you to one real life use of Google Sheets ROWS function. You can use Rows function in Google Sheets...
How to Use Google Sheets Column Function and It's Advanced Use
Column function is not simply to find the column number in Google Sheets. It has a great role in formulas. Google Sheets Column function can be a backbone of many complex worksheet formulas. You can learn here how to use Google Sheets Column function and few advanced tutorials featuring this function. There are two functions related to column number in...
Use of COLUMNS Function in Vlookup in Google Sheets
There is one main advantage in the use of COLUMNS function in Vlookup in Google Sheets. It brings some dynamism to your Vlookup formula. In concise you can replace the "index" argument in Vlookup function with the COLUMNS function. VLOOKUP(search_key, range, index, ) One more thing. I just don't want to mislead you with the title. Because if your index argument in...

Google Sheets Formulas

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...

Inspiration

Get Inspiration from these 5 Best and Popular Inspirational Blogs

There are quite a good number of motivational blogs on the web. Some are purely focusing on motivational quotes, but some others are more...