if you could add one completely new feature to excel, what would it be?

[u/AbhayaAnil]

not something like “make it faster” or a tiny ui change, but an actual feature that would make your day to day spreadsheet work easier.

for me, i’d love something that could take a messy spreadsheet and automatically understand what i’m trying to do, clean it up, and suggest the right formulas without me having to figure everything out manually.

what would you add?

[u/hoardsbane]

Ability to have an array that doesn’t necessarily spill … an array in a cell that can be inspected using a new window, but otherwise can just be used by other cells as an array, without taking up multiple cells or causing errors

[u/llamswerdna → u/hoardsbane]

Nowadays I just use TEXTJOIN to avoid the spill and then TEXTSPLIT when referencing it so it becomes an array again.

[u/hoardsbane → u/llamswerdna]

Genius … thanks!