The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...

I used to rely on Excel's Remove Duplicates tool like a reflex, but it's actually a dangerous, destructive, dead-end process that leaves no visible audit trail. So, I've switched to the UNIQUE ...

Here's my problem: I have an array of ISO dates (e.g., 2005-12-25) returned by a database. I want to:<BR><BR>1. Grab the yyyy-mm part of that data (2005-12)<BR>2. Check to see if that month exists in ...