Excel tip: many values in a single cell!?!?

Hi John

A brand new Excel capability just dropped, and it changes a rule we've all lived with forever.

You might hear it called lists, arrays in cells, or nested arrays, but the headline is simple: one cell can now hold multiple values.

That opens the door to some very cool workflows most Excel users have never been able to do natively before.

I explain more in this short blog post, with screenshots, an embedded video, and a ready-made workbook you can download so you can start using it right away.

• Store multiple reviewers, codes, or values in one cell without flattening everything into plain text.
• Filter, inspect, and work with those values in ways comma-separated text could never handle cleanly.
• See how lists differ from arrays in cells, and where nested arrays fit into the picture.
• Get ideas for using this brand new feature before everyone else catches up.

Click here: Nested Arrays: Multiple Values in a Single Cell

What is the first place in your workbook where you would want one cell to hold multiple real values?

In your corner,
Jeff

P.S. Want to go deeper? Excel University training passes help you level up faster and automate more of the Excel work you repeat every month.