Home Tags Google Doc

Tag: Google Doc

Google Sheets Query Hidden Row Handling with Virtual Helper Column

I am sure that our topic discussing about Google Sheets Query hidden row handling is quite new to you. Yup! Using Google Sheets Query...

SUMIF Excluding Hidden Rows in Google Sheets [Without Helper Column]

SUMIF formula is useful for conditional SUM in Google Sheets. It's quite easy to use. But do you know how to use SUMIF excluding hidden...

Sum by Month in Google Sheets Using Combined SUMIF Formula

Here I'm going to share you a 'magical' SUMIF formula to sum by month in Google Sheets. I'm not exaggerating. See what I am...

Create Month Wise Summary in Google Sheets Using Query Formula

It's not a tough task to create month wise summary in Google Sheets. There are few good options like Pivot, SUMIF and QUERY. How to...

Create GANTT Chart in Google Sheets Using Stacked Bar Chart

Let's see how to create a basic GANTT Chart in Google Sheets with the help of Stacked Bar Chart. This is purely a basic...

How to Compare Two Sheets in Google Sheets for Mismatch

May be you have sufficient reasons to compare two sheets in Google Sheets for mismatch. Whatever it may be, you can easily do it....

Google Sheets LEFT, RIGHT Functions and Alternative REGEXEXTRACT

Unlike Google Sheets REGEX text functions, LEFT, RIGHT functions are very straightforward to use. So little to learn the use of it. Further, you...

How to Use REGEXMATCH Function in Google Sheets

Google Sheets REGEX functions are pure text functions. Among the three REGEX functions, I've already explained the use of REGEXEXTRACT. Other two REGEX functions...

Find and Eliminate Duplicates Using Query Formula in Google Sheets

Learn how to find and eliminate duplicates using Query formula in Google Sheets. I've already shared few awesome tips to find and eliminate duplicates...

How to Use IMPORTRANGE Function with Conditions in Google Sheets

You can't directly use conditions in Google Sheets IMPORTRANGE function. But you can extensively use IMPORTRANGE Function with conditions in Google Sheets with the...

Social

725FansLike
109FollowersFollow
307FollowersFollow