I have a small spreadsheet -- more of a data-base, in fact. It is about 10 columns across, and in the rows are surnames, then firstnames, then other columns with information in them.
The very first column is just numbers 1, 2, 3, etc. and represents the order in which the names have been entered. But instead of typing in the numbers, I put 1 in the first cell, then the next one down is =a1+1 (which gives 2), the next is =a2+1 (which gives 3) , the next is =a3+1 (which gives 4), etc. To get this list, I copied the the formula =a1+1 and pasted it all the way down the column. So all the numbers appear, even though they are still waiting for date to be entered in their rows.
Now I would like to sort Column 2 (surname) with the second sort being Column 3 (firstname), and keep all the information related to each name with it. The columns to the right of the surname, firstname are no problem; they all sort with their related data. However, the first column, with the automatic numbering, does not keep the numbers correctly; in otherwords instead of them appearing something like ; 15, 2, 17 21, etc: (ie, each number attached to the Surname, in the order that the names were entered) stay 1, 2, 3, 4, 5, etc. even though I have included that column in the sort.
So it seems that the cells which have reference to another cell, abide by the formula rather than the result of the formula. I am not completely sure of that, because none of the other cells in this particular sheet have cells referencing other ones.
So, my question is: how can I include the numbers in column 1 in the Sort, so that they stay with the data in their particular row?
Any words of clarity from the wise would be much appreciated.