Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Moving entire ...

Use Excel for web or the Excel for Microsoft 365 desktop app for the latest Excel features, including the newest dynamic array functions. The six functions in this article are available in versions of ...