There is a list of numbers in column A in an Excel worksheet. I would like to display these numbers in column C in order.
Column C should update automatically when column A is modified, without needing to manually reorder anything.
EDIT: Thanks to AFH, the formula can be simplified to just the
This can be done with a very simple normal formula in a Table:
The formula in
A Table is required so that entering a value just below the bottom of the table, i.e. in
A9, will cause the formula in column
C to be extended downwards.
The Table can be dispensed with if only existing data will be modified, or if you are comfortable extending the formula by hand, or if you are prepared to pre-fill it past the current end of the data.