Home Blog Page 2
Google Sheets FIND Function
This time I am detailing you the use of Google Sheets FIND function. You can use this text function the same way that we used with SEARCH function in Google Doc Spreadsheets. There is ONE difference between both these text functions and what is that? I will come to that. How to Use Google Sheets Find Function We can use FIND...
How to Use DPRODUCT Function in Google Sheets
For me DPRODUCT is a very rare to use function in Google Sheets. Still, for those who want to use this database function, here is my tips. Unlike some other functions, this time I know I should address two things related to this formula. The first and foremost one is how to use DPRODUCT function in Google Sheets. The...
Wrap Text Using Formula in Google Sheets
Here I am sharing you an awesome Google Sheets Trick. Do you know you can wrap text using formula in Google Sheets? If not I'm revealing that trick. But before that let me clarify one thing. It's not a perfect word wrap. It has limitation but you can overcome it little bit. Because, with this wrap, you can wrap...
JOIN, TEXTJOIN, CONCATENATE Functions in Google Sheets
There are four ways to join text in Google Sheets. They are using the functions JOIN, TEXTJOIN, CONCATENATE or the Ampersand. I've already explained the use of CONCATENATE as well as Ampersand. Now let us learn the functions JOIN and TEXTJOIN. Also I think you should know the difference of Google Sheets JOIN, TEXTJOIN, CONCATENATE Functions to properly use...
How to Use Google Sheets CHAR Function
Another valuable addition to my Google Sheets Function guide. This time I will explain you how to use Google Sheets CHAR function. Also I will share you how to use CHAR function with QUERY formula. As an example to CHAR formula in QUERY, I will explain you how to filter a range using QUERY based on Tick mark or Check...
First of all let me clarify one thing. VLOOKUP with multiple criteria is possible in Google Sheets! There are two methods to deal with 2 or more criteria or also called search keys in VLOOKUP usage in Google Doc Spreadsheets. I am using Two Criteria here in this example. Also the tips are included to use three or more...
MID, SEARCH Functions in Google Sheets
Most of the Text functions in Google Sheets are easy to use except the RE2 Regular Expression Functions like REGEXEXTRACT. In this post I am explaining you the use of MID, SEARCH functions in Google Sheets. Both are very easy to learn. Usage of MID, SEARCH Functions in Google Sheets Using MID Function is a child's play. I can give you...
Automatically Add Total to a Filtered Data
You can automatically add total to a filtered data in Google Sheets. It can bring much more dynamism to your filtered table. I am talking about filtering data using Google Sheets functions not by using the menu command. In Google Sheets you can use Functions like FILTER or QUERY to filter your Data. Both can return similar output. A normal...
QUERY Function Similar to Pivot Table in Google Sheets
Honestly, I fell in love with Google Sheets QUERY function as it's usefulness is above words. You can use QUERY Function Similar to Pivot Table in Google Sheets. I am going to exactly match a Pivot Table report with a Query Function Report! Before going to the tutorial, see what sample data we have for this purpose. I've a realistic...
Learn What is the Use of ARRAY_CONSTRAIN Formula
Do you know what is the use of ARRAY_CONSTRAIN formula in Google Sheets? Probably not. Because it's not that much popular. But it's definitely a handy function at certain occasions. Also please do not confuse ARRAY_CONSTRAIN Formula with Google Sheets ARRAYFORMULA. Both are entirely different and the latter is much more powerful than the former. First let us learn...

Social

727FansLike
109FollowersFollow
307FollowersFollow