You've hit this scene too

Last Wednesday around midnight, I was helping Xiaoli, who runs a reselling side hustle, reconcile his books. His 200-row client sheet crashed the moment he added a single line.

What it is + who's already using it

Excel quietly shipped a feature called "dynamic arrays" last month—you type a formula once in one cell, and the results automatically populate the entire column next to it.

In plain English: say you've got 100 client names in column A, and you want to auto-match each one's order amount. Before, you had to drag VLOOKUP (a lookup function) 100 times, and every new client meant rewriting the formula. Now you type =XLOOKUP(A1:A100, ...) in B1, hit enter, and B1 through B100 fill themselves in automatically.

Back when I was running my own side hustle, the client reconciliation sheet alone broke on me three times—every formula drag went sideways. So when I saw this feature, I sent it straight to Xiaoli.

Ating, a freelance photographer, started using it last week too. She said she used to rewrite formulas every time she added a client—now she drops a name into column A and the matching amount just appears.

Microsoft is calling it the biggest formula overhaul in Excel's 30-year history. E-commerce sellers, resellers, and small studios in China are already quietly adopting it.

What it costs to set up today

  • Money: $0 (built into Excel)
  • Time: 10 minutes to grasp, 30 minutes to get going
  • Tech barrier: if you can use XLOOKUP or VLOOKUP, you're set—no code involved
  • First step: open Excel → in any blank cell type =UNIQUE(A:A) → hit enter → check whether column A's deduplicated results auto-spread across the cells

If UNIQUE doesn't do anything, your Excel version is too old. Microsoft 365 users basically all have it; WPS users can't use this for now.

How to use it at each stage

Just starting out (0-10 clients):It's fine to skip this for now—manual tracking is totally enough. This feature is for when your sheet starts getting long.

1-2 steady clients:Come back and learn once your sheet crosses 50 rows—you'll save yourself a lot of hassle. Search "dynamic arrays" on Bilibili, there's a pile of free videos.

Scaling up (50+ clients, 1-5 person team):Spend an afternoon on this now. If I'd picked it up earlier, I would've saved myself several all-nighters.

For non-coders:Don't be scared. It's just an Excel formula—same as the VLOOKUP you already learned, just written a little differently.