Work with the example
Can you put these records in quantity order without changing who owns each note? Select the complete ordinary range A4:E7 in Calc, sort by Units ascending and identify row 4 as the header. This is a range exercise, not an automatically growing Excel Table.
| ID/name | Units | Note | Double |
|---|---|---|---|
| R2/Alan | 9 | B | 18 |
| R3/Zoe | 12 | C | 24 |
| R1/Mina | 17 | A | 34 |
Edit the working cells
The download holds that sorted baseline. Append R4,Noah,11,D in A8:D8 and enter =C8*2 in E8. Extend the full sort range to A4:E8; the order becomes R2,R4,R3,R1. If R4 changes to 12, either tied order is acceptable, but its name, note and doubled 24 must stay with R4.
Check the failure case
Sorting columnC alone joins Alan’s name to somebody else’s quantity. The list can look ordered while the records are false. Compare ID/name/units/note together and inspect E formulas after sorting.
Why does adding row 8 require a longer range?
Show the worked answer
An ordinary range sort uses the selected rows. Row 8 would otherwise remain outside it.