## How To Use The TRIM Function In Google Sheets To Clean Your Data

The TRIM function in Google Sheets removes unwanted spaces around text. TRIM removes the leading, trailing, and repeated spaces in the text values in column A.

The formula is:

`=TRIM(A2)`

🔗 Get this example and others in the template at the bottom of this article.

## How To Use The Choose Function In Google Sheets

The CHOOSE Function in Google Sheets lets you choose between different options.

It’s a lookup function, akin to a limited VLOOKUP rather than an alternative to the IF function.

It takes an index number and returns a value at that numbered position from the list of possible options.

Here’s a simple example:

`=CHOOSE(1,"A","B")`

which will output: The first argument is the index number: 1.

Subsequent arguments are possible choices. The CHOOSE function returns the value at index position 1 in this case, i.e. “A”.

If I changed the index number to 2, the CHOOSE function would output “B”.

🔗 Get this example and others in the template at the bottom of this article.

## How To Rank Data In Google Sheets With The RANK Function

Google Sheets has three functions to rank data: the RANK function, the RANK.EQ function, and the RANK.AVG function.

All three functions return the rank (position) of a value in a dataset.

RANK and RANK.EQ are equivalent to each other and return the top rank for values that are tied. RANK.EQ is the more modern notation, to explicitly differentiate itself from RANK.AVG.

The RANK.AVG function differs by returning the average rank of any entries that are tied.

Consider this dataset showing the three RANK functions in action, with a tie highlighted in yellow: Both RANK and RANK.EQ display the tied values with the rank 5, whereas RANK.AVG shows the average rank of 5.5 (i.e. the average of position 5 and position 6).

The RANK formula in column C:

`=RANK(B2,\$B\$2:\$B\$11)`

And RANK.EQ formula in column D, giving the same answer:

`=RANK.EQ(B2,\$B\$2:\$B\$11)`

Finally, RANK.AVG formula is in column E:

`=RANK.AVG(B2,\$B\$2:\$B\$11)`

🔗 Get this example and others in the template at the bottom of this article.

## How To Use The IMPORTRANGE Function In Google Sheets To Transfer Data From One Sheet To Another

Since Google Sheets are files in the cloud, not on your desktop, you can’t click on a cell in a different Sheets file to connect them.

Instead, you use the IMPORTRANGE function in Google Sheets to connect Google Sheet files and import data from one Sheet file into another.

Once set up, the function will automatically sync with the source data so that changes are reflected in the destination Sheet. If you look closely, you’ll see a URL in the formula — the URL of the source Google Sheet file, where the data is being imported from.