How to Remove Duplicates in Google Sheets Using the UNIQUE Function [VIDEO]

Google Sheets doesn’t have a Remove Duplicates option, like Excel does. However, you can still use Google Sheets for your duplicate data removal needs! In this video, I’ll show you how to remove duplicate values from a list in Google Sheets using the UNIQUE function. I really wish Excel had this function. Two other mad-cool Google Sheets […]

How To Import One Spreadsheet Into Another In Google Drive [VIDEO]

At YourTango, I work with an editorial team. And editorial teams love working in Google Docs. I’ve never seen so many in my life. But managing them can be a bear because sometimes you have to have multiple Google Docs open in different tabs to provide context for the research you’re doing. So I’ve been exposing […]

Email Attachments Up To 10GB Using Google Drive

I noticed an extra icon in my Gmail and decided to explore it. Turns out, Google has dialed up its Gmail/Drive integration by allowing users to send large files with Drive — up to 10gb. In an effort to nudge people to use its new compose feature, Google added this feature. But it doesn’t work […]

How To Use Google Docs’ JOIN And SPLIT Functions

  Google Docs offers two functions in its spreadsheets that Excel doesn’t: JOIN and SPLIT. They are the finessed alternatives to Excel’s CONCATENATE function and its scorched earth Text to Columns command. JOIN Function Let’s say you want to create a regular expression (regex) that joins together (geek speak: concatenates) a bunch of cities separated by […]