Excel’s New List Cells: Three Owners Still Make One Project
Multiple values in a cell make room for a useful reporting question: what exactly are we counting?
One project has three owners. The tracker is accurate. Then someone adds up the project counts by owner and announces three projects.
The team has expanded considerably without doing any additional work.
Microsoft’s September 24 announcement introduces lists, arrays in cells, and nested arrays in Excel. These let a cell hold multiple related values. The initial release is to Excel’s Windows and Mac Beta Channels, so availability depends on your installation. techcommunity.microsoft.com
Microsoft’s announcement describes new ways to keep related information together while supporting filtering and calculations. Windows Latest covered the update the following day.
For teams maintaining project trackers, the interesting part is what happens when one record belongs to several people.
Two projects, four owner assignments
Consider this fictional tracker. The owners column illustrates the contents of a list, rather than a formula or a screenshot of Excel.
| Project ID | Owners | Project budget |
|---|---|---|
| P-101 | Maya, Lee, Sam | $12,000 |
| P-102 | Maya | $8,000 |
There are two projects, three distinct people, and four owner assignments. The total project budget is $20,000.
Maya is attached to two projects. Lee and Sam are each attached to one. Adding those counts produces four assignments, not four distinct projects.
The same distinction matters for money. If a report gives every owner the full budget of each project they participate in, Maya’s associated budget is $20,000, Lee’s is $12,000, and Sam’s is $12,000.
Those figures add to $44,000 because the shared project appears under three people. The company still has $20,000 of project budget.
When a record has multiple owners or tags, count unique record IDs for an overall total. Use owner-level figures to describe participation, and define an allocation rule before treating them as shares of the budget.
Decide what the report should mean
A project manager may want to see every project each person touches. Finance may need each project budget counted once. Both requests are reasonable, but they need different calculations.
Keep a stable project ID. Label whether a figure represents distinct projects, assignments, or allocated cost. If costs must be split between owners, record the agreed shares rather than assuming equal ownership means equal cost.
Before adopting the new cells in a reporting workbook, check that the Excel versions and downstream tools your team uses preserve the values and produce the expected totals. This example explains a counting rule; it is not a compatibility test.
At Jolene.pro, our focus is spreadsheet analysis with references back to the source cells, rows, and sheets. Support for Excel’s new native list cells still needs verification before we recommend using them with Jolene.pro.
A cell can hold more information. The report still needs to say what its number means.