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.
How-To Geek on MSN
How to randomize rows in an Excel table without scrambling your data
Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually ...
Use the Sharpe ratio to evaluate an asset's risk vs. return Yarilet Perez is an experienced multimedia journalist and fact-checker with a Master of Science in Journalism. She has worked in multiple ...
Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Andy Smith is a Certified Financial Planner (CFP®), licensed realtor and educator with over ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback