Dealing with duplicates can be a hassle! Here’s one option to add to your toolbox.
Conditional Formatting lets you highlight duplicate or unique values in a column. Check out how to do it below!
p.s. You can get more spreadsheet tips straight to your inbox by subscribing here! –> Or, if you just want the vids, follow the !) Employed for Good Youtube Channel VIDEO
When you need staff to add data to a spreadsheet, you can end up with lots of inconsistencies. Here’s how to use
data validation to create drop-down lists, so that data is entered accurately and uniformly! VIDEO
For any of you who work with spreadsheets too, you know those things can cost us lots of time! So I’m experimenting and sharing a few of the must-know tips via video.
For the first video in this series, check out
how you can quickly format names, addresses, and organizations to have the proper capitalization! VIDEO