How to Highlight Duplicates in Google Sheets

Google Sheets logo

Google Sheets can be used to highlight duplicates in a spreadsheet. How the repeats are displayed is fully customizable in the formatting style options. This can be used to represent specific reasons for why a duplicate was highlighted so it makes sense to anyone looking at the data. For instance, you can highlight the entire row of a given column containing any duplicates. Or, alternatively, it can also be formatted to simply highlight any cell with a value that appears more than once in the spreadsheet. Continue reading

[Solved] Internet Disconnects While Streaming on Discord

Discord logo

If you’ve ever had your internet disconnect in the middle of streaming your screen or game on Discord, there’s a simple option buried in Discord’s settings that may solve your problem. For some reason, a setting where Discord admits “some routers or internet service providers may misbehave when this is set” is enabled by default. In this guide, we’ll show you how to turn it off.
Continue reading