I have some words in column B. They are sorted by a personal criterion, nothing that Apple Numbers can consider:
At a certain point, I want to organize the information by another criterion. For instance, to make it simple, sort ascending:
Is there a way I can go back to the first picture?
(Here I simplify the case. Of course, I could cmd z, but that is not the point. I am looking for an easy way to save a specific order even after I close the file o even days later)
What I have tried:
This is a simplified case. In real live I have several files with thousands of rows in each file. I cannot create a column and give them a number of reference manually. I tried to create a column and generate the order this way:
1- I put 1 in A1
2- Put A1+1 in A2
3- Copy paste the formula in the other columns. Or drag the yellow point, it's the same
4- Create another column and "paste results" (When I sort by the B column the formula column will change. That's why I need that extra step and create a column with only numbers)
This works, but it seems complicated and I need to do it many times. Is there any other way to save the order that is easier, simpler?
Best Answer
Simply create an Index column. 1, 2, 3 etc. (As pjctec mentions in comments.). Without some ordered list or index, there is no way for Numbers to know how to use a custom sort.
There is no need to use a formula to create the list of numbers.
A1
enter1
A2
enter2
A3
enter3
A1 to A3
Sorting will not change the numbers as they are static. No need to use a formula.
Then you can always sort the index column later. If needed, the column can be hidden or shown when needed.
Apple supplies a good resource for Numbers basics on their Website. Numbers Help. Recommended for new users and anyone who wants to get the most out of using Numbers.