How-To Geek on MSN

Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.
How-To Geek on MSN

Excel LAMBDA vs. SCAN: What's the difference and how do they work together?

LAMBDA defines the custom logic, and SCAN moves that logic through your data range.