Import automatically CSV file to Google Sheets

People who work with several data usually process them with statistical software in order to perform advanced calculus that is only possible with these software tools. However, for the actual representation of the data and the sharing of the results with … Read More

How to use the TRANSPOSE formula in Google Sheets

In Google Sheets, if we ever need to flip (or transpose) the columns and rows of an array or a data range, TRANSPOSE formula is the one to go with. Syntax TRANSPOSE(array_or_range) array_or_range – the array or the address reference … Read More

How to use the SUMPRODUCT formula in Google Sheets

The SUMPRODUCT formula in Google Sheets multiplies corresponding items within the arrays of equal size and returns the sum of the results. We come across many such situations where we need to multiply items across arrays and add them up. … Read More

How to use the ARRAY_CONSTRAIN formula in Google Sheets

In Google Sheets, the ARRAY_CONSTRAIN formula returns a subset of the input range, characterized by the specified number of rows and columns. In other words, the formula restricts or constraints the size of input range by the specified number of … Read More

How to use the FILTER formula in Google Sheets

The FILTER formula in Google Sheets helps us filter and return the rows in a range that meet specified criteria. And, we can add multiple criteria across columns. Accordingly, we will be able to generate a new set of data … Read More

How to use the DAVERAGE formula in Google Sheets

The DAVERAGE formula in Google Sheets is almost similar to that of the AVERAGE formula, but with a distinction. It gives us the average of values available in a table like range, that meet a specified criteria. This is analogous … Read More

Automatically receive data from another spreadsheet

If you are used to working with spreadsheets, maybe you have faced the situation of doing a lot of copy-paste work whenever you wanted to import data from another spreadsheet into one of yours. This manual approach may work well … Read More

Export data with conditions in Google Sheets

If you work with Google Sheets, you probably know that you can share any spreadsheet with your colleagues for them to suggest changes or to have view-only access to your data. However, the current permissions level of Google Sheets only … Read More

Track selected data from one spreadsheet to another one

Lets assume you need to append some historical information from another spreadsheet to the bottom of the data set in your current one. So, if you want to append data, track selected data can be complicated. How to track selected … Read More

Backup data from Excel file to Google Sheets

Usually, people work with Excel files because it is the standard application to be used in offices. This situation, however, is changing because there is other spreadsheet software that are less costly or that have other features that Excel does … Read More