Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:05,500 --> 00:00:10,090
So now we know how to sort on one column or multiple columns.
2
00:00:10,750 --> 00:00:16,600
The final sort option I want to show you is how to sort using your own custom list.
3
00:00:16,810 --> 00:00:19,640
Now what do we mean by sorting using a custom list?
4
00:00:20,440 --> 00:00:25,330
Well, it might be that you have a data set that you want sorted in a very specific way.
5
00:00:25,840 --> 00:00:30,670
One that is outside the boundaries of simply sorting A2Z or said to.
6
00:00:31,150 --> 00:00:37,840
For example, if we take Column Ajuste just here, you can see that I basically have three items Miss
7
00:00:38,050 --> 00:00:39,670
Mrs and Mr.
8
00:00:39,880 --> 00:00:46,420
Now, if I want to sort this data set A2Z, I can write Glink go to salt and A2Z, and it's going to
9
00:00:46,420 --> 00:00:51,010
put the messages at the top, the Mr's in the middle and the misses at the bottom.
10
00:00:51,790 --> 00:00:58,780
If I right click and sort Zed to a, it's going to put the misses at the top, the Mr's in the middle
11
00:00:58,780 --> 00:01:00,280
and the miss at the bottom.
12
00:01:01,300 --> 00:01:04,750
Now in either of those two options, I don't get Mr.
13
00:01:04,780 --> 00:01:06,310
At the top of my sort.
14
00:01:07,030 --> 00:01:08,850
And what if I actually need them?
15
00:01:08,860 --> 00:01:14,290
Maybe I need to sort this list by Mr. First, then miss, then Mrs.
16
00:01:14,950 --> 00:01:17,800
Well, this is where we can use a custom salt.
17
00:01:18,130 --> 00:01:23,830
Now, the first thing you would need to do here is basically write our type out your list in the salt
18
00:01:23,830 --> 00:01:25,060
order that you prefer.
19
00:01:25,210 --> 00:01:30,580
So in a blank cell somewhere over here, I'm going to write my salt order so I won't miss the first.
20
00:01:31,300 --> 00:01:33,040
Then I won't miss.
21
00:01:33,220 --> 00:01:35,110
I'm then I want Mrs.
22
00:01:35,830 --> 00:01:39,160
And I can set this up as a custom list.
23
00:01:39,370 --> 00:01:48,730
So to create a custom list, we need to go into file down to options and into our advanced settings.
24
00:01:49,570 --> 00:01:56,920
Now, if we scroll all the way down to the bottom and it is quite a way down in the general section,
25
00:01:56,920 --> 00:02:03,400
we can edit our custom lists and custom lists are basically those lists that when you typed the first
26
00:02:03,400 --> 00:02:07,450
one in, you can then use your fill handler to drag down and complete the others.
27
00:02:07,810 --> 00:02:11,770
And you might be more familiar with that when you're typing end dates or months of the year.
28
00:02:12,460 --> 00:02:17,200
You can see that I also have some other custom lists that I've created in here as well.
29
00:02:18,010 --> 00:02:24,670
So I'm going to set up my sort order as a custom list, and because I have them typed out in the cells
30
00:02:24,670 --> 00:02:26,950
over here, I can choose to import them.
31
00:02:27,730 --> 00:02:31,370
Now you don't have to import them from cells in a spreadsheet.
32
00:02:31,390 --> 00:02:37,690
You could choose to create your own new list and simply type the entries in this box here, but we're
33
00:02:37,690 --> 00:02:38,530
going to import them.
34
00:02:38,770 --> 00:02:43,210
So let's just simply select the list and click import.
35
00:02:43,990 --> 00:02:46,780
So there is my new custom list.
36
00:02:47,290 --> 00:02:48,850
Let's click on OK.
37
00:02:49,920 --> 00:02:57,600
And OK, again, so now I have those set up as a custom list, what I can do is use that custom list
38
00:02:57,600 --> 00:03:00,150
as the sort order for my data.
39
00:03:00,300 --> 00:03:05,880
So on the Home tab, let's go to sort of filter and into custom sort.
40
00:03:07,290 --> 00:03:12,990
So now I'm going to salt by the title, I want to salt on the cell values.
41
00:03:13,320 --> 00:03:17,430
But the older I want to use is determined by a custom list.
42
00:03:18,300 --> 00:03:21,270
I can then just simply select my custom list.
43
00:03:21,600 --> 00:03:24,270
Click on OK, click on OK again.
44
00:03:24,690 --> 00:03:28,200
And it's supplied my very specific sort order.
45
00:03:28,440 --> 00:03:32,370
Now, if I was to go and delete these entries from here, let's just delete those out.
46
00:03:32,550 --> 00:03:34,890
It doesn't affect that sort order at all.
4619
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.