Google Sheets Archives - Page 12 of 40

How to Concatenate in Google Sheets (6 Suitable Ways)

August 16, 2023 Formulas

Sometimes it is necessary to join or concatenate information from different cells, columns, or rows. To perform this, copy-paste is handy until you ...

How to Concatenate in Google Sheets (6 Suitable Ways)

How to Remove Spaces Between Words in Google Sheets

August 16, 2023 Basics

Excess spaces in data can make it difficult to read and analyze, but Google Sheets can easily remove them. This article will show you how to use ...

How to Remove Spaces Between Words in Google Sheets

How to Paste Comma Separated Values in Google Sheets

August 16, 2023 Basics

While working on a dataset sometimes we get different types of data, and we get to modify that data in suitable ways. If you paste any value from ...

How to Paste Comma Separated Values in Google Sheets

How to Use COUNTIF Function in Google Sheets (7 Examples)

August 16, 2023 Functions

The COUNTIF function is one of the most frequently used functions in Google Sheets. This function is helpful for counting the number of cells that ...

How to Use COUNTIF Function in Google Sheets (7 Examples)

How to Add Space with CONCATENATE in Google Sheets

August 16, 2023 Advanced

Concatenation is basically another word for combining or joining together. You can merge text from various cells into a single cell by using the ...

How to Add Space with CONCATENATE in Google Sheets

[Fixed!] Google Sheets If VLOOKUP Not Found (3 Suitable Solutions)

August 16, 2023 Formulas

The VLOOKUP function is a popular and effective function in Google Sheets. Users apply this function quite often to find data from columns in large ...

[Fixed!] Google Sheets If VLOOKUP Not Found (3 Suitable Solutions)

How to Remove Unique Values in Google Sheets (2 Suitable Ways)

August 3, 2023 Formulas

In Google Sheets, you might sometimes need to work with repetitive entries and remove the unique values. Finding unique data and deleting them one by ...

How to Remove Unique Values in Google Sheets (2 Suitable Ways)

How to VLOOKUP for Partial Match in Google Sheets

August 16, 2023 Formulas

In Google Sheets, with the help of an asterisk wildcard (*) in the VLOOKUP function, you can look up values that have a partial match with certain ...

How to VLOOKUP for Partial Match in Google Sheets

How to Use COUNTIF Function with OR Logic in Google Sheets

August 16, 2023 Formulas

The COUNTIF function is a great tool to count any values both texts and numbers with single criteria. But the problem arises when we want to use it ...

How to Use COUNTIF Function with OR Logic in Google Sheets

COUNTIF with Greater than and Less than Criteria in Google Sheets

August 3, 2023 Formulas

In our day-to-day use of Google Sheets, we sometimes need to count values that are greater or less than a given value. The COUNTIF function is a ...

COUNTIF with Greater than and Less than Criteria in Google Sheets

How to HLOOKUP for Multiple Criteria in Google Sheets (2 Ways)

August 3, 2023 Formulas

Users who frequently work with huge spreadsheets may wish to look for a value that belongs to a specific category and doing so manually might be ...

How to HLOOKUP for Multiple Criteria in Google Sheets (2 Ways)

Use INDEX MATCH Across Multiple Sheets in Google Sheets

August 16, 2023 Formulas

INDEX MATCH makes it easier to find the data you need, especially if you have multiple sheets across Google Sheets from which to retrieve data. ...

Use INDEX MATCH Across Multiple Sheets in Google Sheets

How to Freeze Specific Columns in Google Sheets (3 Quick Ways)

August 16, 2023 Basics

We often work with large datasets in Google Sheets. When datasets are larger than the screen size, we need to scroll down or move right to view more ...