How-To Geek on MSN

How to pick a random name from a list in Excel

To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...
How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.

Build Faster Excel Workflows Using FILTER, IFS, XLOOKUP, and LET for Real-World Data

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...
AOL

Licorice Extract Can Fade Dark Spots (Yes, Really)—Here's Exactly How Derms Say to Use It

Licorice extract inhibits tyrosinase production to effectively minimize dark spots and even out skin tone. It's safe to use licorice extract up to twice daily, though it may irritate sensitive skin.