Move the dynamic array formula to a location outside the formatted table. Alternatively, convert your formatted Excel table to an unformatted range by selecting one of the cells within the table ...

Explore Excel's latest features for 2025, from AI-powered Copilot to Python integration, and transform your workflows.