Filtering for exact order of words

[Girol]

Hello,

I want to filter below column for PASIR GUDANG - SINGAPORE exact order.


[TABLE="width: 109"]
<colgroup><col></colgroup><tbody>[TR]
[TD]DURBAN[/TD]
[/TR]
[TR]
[TD]MUNDRA[/TD]
[/TR]
[TR]
[TD]KANDLA[/TD]
[/TR]
[TR]
[TD]PASIR GUDANG[/TD]
[/TR]
[TR]
[TD]PASIR GUDANG[/TD]
[/TR]
[TR]
[TD]PASIR GUDANG[/TD]
[/TR]
[TR]
[TD]SINGAPORE[/TD]
[/TR]
[TR]
[TD]KUALA TANJUNG[/TD]
[/TR]
[TR]
[TD]PORT LOUIS
PASIR GUDANG[/TD]
[/TR]
[TR]
[TD]MAPUTO
SINGAPORE [/TD]
[/TR]
[TR]
[TD]BELAWAN[/TD]
[/TR]
[TR]
[TD]BELAWAN[/TD]
[/TR]
[TR]
[TD]BELAWAN[/TD]
[/TR]
[TR]
[TD]PASIR GUDANG[/TD]
[/TR]
[TR]
[TD]SINGAPORE[/TD]
[/TR]
[TR]
[TD]KUALA TANJUNG[/TD]
[/TR]
[TR]
[TD]DURBAN[/TD]
[/TR]
[TR]
[TD]CAPE TOWN[/TD]
[/TR]
[TR]
[TD]SANTOS[/TD]
[/TR]
[TR]
[TD]PARANAGUA[/TD]
[/TR]
[TR]
[TD]PARANAGUA[/TD]
[/TR]
[TR]
[TD]SANTOS[/TD]
[/TR]
</tbody>[/TABLE]

If there is another city between, this should not be in the list.
[TABLE="width: 109"]
<tbody>[TR]
[TD]PASIR GUDANG[/TD]
[/TR]
[TR]
[TD]MAPUTO
SINGAPORE

[/TD]
[/TR]
</tbody>[/TABLE]

I hope you can help me with this.

 

[shg]

Welcome to the board.

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

City​

[/td][td="bgcolor:#F3F3F3"]

Filter​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]DURBAN[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td]B2: =(A2="PASIR GUDANG")*(A3="SINGAPORE") + (A2="SINGAPORE")*(A1="PASIR GUDANG")[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]MUNDRA[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]KANDLA[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]PASIR GUDANG[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]PASIR GUDANG[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]PASIR GUDANG[/td][td="bgcolor:#E5E5E5"]

1​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]SINGAPORE[/td][td="bgcolor:#E5E5E5"]

1​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]KUALA TANJUNG[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]PORT LOUIS[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]PASIR GUDANG[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]MAPUTO[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]SINGAPORE[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]BELAWAN[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

15​

[/td][td]BELAWAN[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

16​

[/td][td]BELAWAN[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

17​

[/td][td]PASIR GUDANG[/td][td="bgcolor:#E5E5E5"]

1​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

18​

[/td][td]SINGAPORE[/td][td="bgcolor:#E5E5E5"]

1​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

19​

[/td][td]KUALA TANJUNG[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

20​

[/td][td]DURBAN[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

21​

[/td][td]CAPE TOWN[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

22​

[/td][td]SANTOS[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

23​

[/td][td]PARANAGUA[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

24​

[/td][td]PARANAGUA[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

25​

[/td][td]SANTOS[/td][td="bgcolor:#E5E5E5"]

0​

[/td][td][/td][/tr]
[/table]

 

[Peter_SSs]

You could also use Advanced Filter if you have a heading above the list.
I have the required order in H1
G1 is blank and G2 holds the formula shown

Book1
	A	B	C	D	E	F	G	H
1	Location							PASIR GUDANG-SINGAPORE
2	DURBAN						FALSE
3	MUNDRA
4	KANDLA
5	PASIR GUDANG
6	PASIR GUDANG
7	PASIR GUDANG
8	SINGAPORE
9	KUALA TANJUNG
10	PORT LOUIS
11	PASIR GUDANG
12	MAPUTO
13	SINGAPORE
14	BELAWAN
15	BELAWAN
16	BELAWAN
17	PASIR GUDANG
18	SINGAPORE
19	KUALA TANJUNG
20	DURBAN
21	CAPE TOWN
22	SANTOS
23	PARANAGUA
24	PARANAGUA
25	SANTOS
Adv Fltr

Cell Formulas
Range	Formula
G2	=OR(A1&"-"&A2=H$1,A2&"-"&A3=H$1)

Select A1:A?? (or your whole data range) and use Advanced (in the 'Sort & Filter' section of the Data ribbon tab)
Click OK if Excel says it can't determine the list.
Filter the list in place, Criteria range: G1:G2, OK

Result:

Book1
	A
1	Location
7	PASIR GUDANG
8	SINGAPORE
17	PASIR GUDANG
18	SINGAPORE
Adv Fltr