How-To Geek on MSN

How to Use the DROP Function in Microsoft Excel

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...
MUO on MSN

If you’re still nesting IFs in Excel, you’re doing it the hard way

First, try revisiting a deeply nested IF formula six months later and making sense of it. Good luck finding the right spot to add another condition without accidentally breaking the entire chain. If ...
TechRepublic

How to extract a list of duplicate values across two columns in Excel

How to extract a list of duplicate values across two columns in Excel Your email has been sent There are a number of ways to highlight duplicate values. Conditional formatting might be the most common ...
TechRepublic

How to concatenate values in a single Excel column to a single row

How to concatenate values in a single Excel column to a single row Your email has been sent Sometimes the current Microsoft Excel data structure doesn’t match ...