Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Why did sorting the names leave our spreadsheet's other columns with the wrong people?

Technology category photographTechnology

The names are alphabetical now, but my colleague spotted that her shift was beside somebody else. I selected the name cells in Excel and chose to continue with the current selection when a warning appeared.

The worksheet holds names, shifts and meal choices in neighbouring columns. I thought the warning was about which names I wanted sorted. Microsoft's guidance warns that sorting part of a larger range can separate it from its associated data. Excel's sorting guidance

I haven't sent the sheet to the caterer, and we have an earlier copy. How should I restore the relationships and sort the list safely? Alphabetical names are no use if the rest of each row belongs to someone else.

Discussion

5 community replies

Stop using the changed list for decisions. If the sort has just happened and Undo is available, that is one option; otherwise work from the known earlier copy and account for later changes. Don't try to repair associations by matching people from memory. Excel's warning and Undo guidance

When each row describes one person, the whole record needs to move together. Microsoft's guidance explains the distinction between expanding the selection and continuing with only the selected cells. Check the intended range, including every related column, before sorting again. Sort a range within a larger range

An orderly-looking name column can conceal a serious practical mistake here. Verify the meal and shift associations against the trusted record, not just the alphabetical order. Those are the details the caterer and rota organiser will act on.

Before resending, ask the colleague to check a few known records against the recovered source. Another pair of eyes could catch a missing update or an incomplete sort range, especially since she has already noticed an association you missed.

That check is helpful, but a few correct records wouldn't prove all the others recovered correctly. Establish a sound source for the full list first; use the spot check as an extra check on that process, rather than the basis for declaring every row fixed.

Join the discussion

More in Technology