Most Excel users know Ctrl+F as a quick way to find specific text or values in a spreadsheet. You might also know Ctrl+H, but probably think of it as little more than a way to replace one value with ...

Microsoft Excel's UNIQUE function does exactly as its name suggests—it extracts unique values from an array. In other words, you'll only see each value once in the result, even if it appears multiple ...