How do I sort a column and retain the relationship to other data in the spreadsheet?
Maybe that's not the best way to express the problem ...
I have a spredsheet with two columns and 2390 rows.
Column 1 is a "record number" and Column 2 is a unique data point
When I sort by column 2 Column one stays static (e.g., the record number doesn't "follow" the unique data point.
I've tried sorting by by the "entire table" ... but it won't unless I pick a column ... and then we end up with the problem I've described.
Any suggestions?
Thanks for your assistance!
Bill Arnold
<Email Edited by Host>
Numbers 3.1