Google Sheets can transform your data in so many ways. But do you know these 5 spreadsheet tips? In this video, Scott Friesen shares his favorite ways of managing and editing data within Google Sheets.
Here is the formula you will need to use for Tip #4. Just remember to replace 'A1' with the cell you want to reference: