ARRAYFORMULA Function

### How to Use REPLACE Function in Google Sheets (4 Examples)

Google sheets is a handy tool while editing and replacing data from a large dataset. Using the REPLACE function users can easily and quickly replace ...

### How to Split Text to Columns Based on Line Break in Google Sheets

With Google Sheets' Split text to columns based on line break feature, you can break up text into numerous cells based on where lines break. When a ...

### How to Insert Formula in Google Sheets for Entire Column

Suppose you are working on a dataset where you need to apply formulas but this work will be difficult if you work on a complicated dataset or a large ...

### How to Fill Column with Dates in Google Sheets (2 Easy Ways)

Google sheets one of the most useful features is to fill a column or row with a series of dates automatically. This can save time and prevent errors. ...

### How to Insert Blank Column Using QUERY in Google Sheets

Often we need to insert one or more blank columns between columns in order to input data that we forgot to insert previously. So it is necessary to ...

### How to Subtract Two Cells in Google Sheets (4 Simple Ways)

Subtraction is a simple mathematical process of finding the difference between two numbers. Though it is a simple thing in practical life, it can be ...

### Calculate Standard Deviation with IF Condition in Google Sheets

Standard deviation is a famous statistical tool in Google Sheets that we use often to measure the spread of values from the actual average values. We ...

### How to Use QUERY with SPLIT Function in Google Sheets

We often need to split a large text string and rearrange them within different columns. Like, if a company has a dataset that contains information on ...

### How to Insert Serial Numbers in Google Sheets (7 Easy Ways)

Inserting numbers or serial numbers in Google Sheets is very simple and easy. But there are various ways to do it. And some methods are useful ...

### How to Make REGEXMATCH Case Insensitive in Google Sheets

The REGEXMATCH function is a very helpful tool in Google Sheets. However, this function is case-sensitive. So, sometimes it eliminates some matches ...

### Use COUNTIF Function to Count Unique Values in Google Sheets

Using the COUNTIF and UNIQUE functions in Google Sheets can greatly benefit businesses and finance professionals by quickly identifying and tracking ...

### How to Use COUNTIF for True Condition in Google Sheets

By using the COUNTIF function to find TRUE conditions and values in Google Sheets, a business can quickly and easily count the number of times a ...

### How to Split Text to Columns Using Formula in Google Sheets

In order to properly extract meaning from the data that has been gathered, text strings must be split as a necessary first step in data analysis. For ...

### Use COUNTIF If Cell Contains Specific Text in Google Sheets

In business and finance, it's essential to analyze data quickly and accurately. One way to do this is by using the COUNTIF function in Google Sheets ...

### How to Concatenate Values for IF Condition in Google Sheets

In Google Sheets, you can combine cells by using some functions. CONCATENATE, JOIN and TEXTJOIN are the most popular among them. To apply some ...