Microsoft Enhances Excel with Dynamic Arrays

Buzz

Ngày cập nhật gần nhất: 15/4/2026

The software giant, Microsoft, has just announced significant improvements to how formulas operate in Excel. Among the additions is a new feature called Dynamic Arrays, initially revealed last year but only accessible to a small group of Office Insider users.

In a blog post, the company highlighted the notable limitations of formulas in the spreadsheet editor, such as each formula outputting data for just one cell in the spreadsheet. To overcome this, Microsoft introduces and enhances Dynamic Arrays in Excel, enabling formulas to return multiple values on the spreadsheet in list form.

In addition to Dynamic Arrays, Microsoft introduces several new formulas that yield various results, including SORT, SORTBY, UNIQUE, FILTER, SEQUENCE, and RANDARRAY. For example, the UNIQUE formula empowers users to select a list of cells with different values, filter out duplicate values, and return a list of all unique values in the selected cells, replacing the previous method of Removing Duplicate Data in Excel.

Dynamic Arrays are now available for all Office Insider users on Windows and those subscribed to the Fast ring on macOS. Microsoft plans to roll out this feature for users on all available Office platforms, including Office 2019 and versions dating back to 2016.

Visit Mytour every day to stay updated on the latest technology news. Additionally, information about Huawei quietly adding ads to the lock screen of mobile devices from the company is currently attracting significant user attention.

Frequently Asked Questions

What are the main benefits of using Dynamic Arrays in Excel?

Dynamic Arrays in Excel allow formulas to return multiple values in a list format, enhancing data analysis capabilities and making it easier to manage and visualize information within the spreadsheet.

Which new formulas have been introduced with the Dynamic Arrays feature?

Microsoft has introduced several new formulas including SORT, SORTBY, UNIQUE, FILTER, SEQUENCE, and RANDARRAY, which provide advanced data manipulation options and enhance functionality in Excel.

Who can currently access the Dynamic Arrays feature in Excel?

Dynamic Arrays are currently available for all Office Insider users on Windows and those subscribed to the Fast ring on macOS, with plans for wider rollout across all Office platforms.

How does the UNIQUE formula improve data management in Excel?

The UNIQUE formula allows users to filter out duplicate values from a list, simplifying data management by automatically generating a list of all unique values from selected cells.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]