Filter Not Sorting Correctly

[Jtucker10278]

so I have a spread sheet that has

	A	B	C	D	E	F	G
1	#	#	Formula	Formula	Text	Text	Text
2	#	#	Formula	Formula	Text	Text	Text

<tbody>
</tbody>

(slightly simplified but that is the general idea)

Column C hidden and column F is hidden

I added the Filters to the top row and when i tell Column E it to sort A to Z It almost gets it right but not quite, its like something else has the priority to sort by first but i cant figure out what that is or where. I have tried Clearing and removing all filters then re adding the filters back but still no working right

Actual spreadsheet below

	A	B	C	D	E	F	G	H	I	J	L	M	N	O	S	T	U	V	W	X	Y
3		MCv	MC		RTv	RT		#	IMDB		AVG		Service	Title	Genre	Co	Ep	Year		H
4		85	65		75			3	77		76		Acorn TV	The Crimson Petal and the White	Dra-Rom-Per	UK	4	2011
5		82	73		93	94		73	85		85		Amazon	Outlander	Rom-Fan-Per	USA	44	2014		H
6		67	91		80	100		5	85		85		Amazon	The hollow crown	Dra--Per	UK	7	2012
7		74	82		78	100		1	79		81		Amazon	At home with any Sedaris	Com--	USA	10	2017
8		74	86					8	82		81		Amazon	Wolf Hall	Dra--Per	UK	6	2015
9		76	61		100	76		5	80		79		Amazon	The Unusuals	Com-Dra-	USA	10	2009
10		87	67		78	72		2	70		73		Amazon	Babylon	Dra-Cri-	UK	7	2014
11		74	71		50	88		3	73		72		Amazon	Inside Men	Cri-Dra-	UK	4	2012
12		65	56		82			16	74		71		Amazon	Sanctuary	Dra-Fan-Mys	Canada	59	2008
13		67	51		80			5	74		70		Amazon	Motive	Cri-Dra-Mys	Canada	52	2013
14		86	85					8	85		85		Brittbox	State of Play	Cri-Dra-Mys	UK	6	2003		H
15		87	75					16	84		83		Brittbox	Jane Eyre	Dra-Rom-Per	UK	4	2006
16		69	80		100			6	79		81		Brittbox	The Take	Cri-Dra-Thr	UK	4	2009
17		81	75		94	92		60	86		86		HBO	Big little lies	Cri-Dra-Mys	USA	12	2017		H
18		73	85		91	97		8	81		84		HBO	Show me a hero	Dra-His-	USA	6	2015
19		74	76		86	90		56	82		82		HBO	The leftovers	Dra-Fan-Mys	USA	28	2014
20		76	69		95	73		15	77		78		HBO	Mildred Pierce	Dra--	USA	5	2011

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Edit​

	A	B	C	D	E	F	G	H	I	J	L	M	N	O	S	T	U	V	W	X	Y
61		77	78		82	83		6	73		77		Starz	The Girlfriend Experience	Dra--	USA	27	2016
62		63	71		82	79		4	77		75		Starz	The white Princess	Dra--Per	USA	8	2017
63					50	50		1	71		61		Hulu	Trust Me	Dra-Thr-	UK	4	2017
64					100			10	85		93		Hulu	Line of Duty	Cri-Dra-Mys	UK	31	2012
65								14	84		84		Netflix	Conspiracy	Glo-Doc-Doc	USA	1.25	2014		H
66								8	83		83		Netflix	The Keepers	Dea-Doc-Doc	USA	7	2017
67								12	82		82		Brittbox	Emma	Com-Dra-Rom	UK	4	2009
68					87			4	82		85		Not Found	The Shadow Line	Cri-Dra-Thr	UK	7	2011
69								3	82		82		Netflix	Top Boy	Cri-Dra-Thr	UK	8	2011

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Edit​

 

[frank_AL]

I copied your data into Excel and when I Sorted on Column E I got the same result. I believe the issue is that there are blank cells in your data and the sort is stopping on the first blank cell. I highlighted the entire range and then when I Sorted on Column E I got the expected result.

	MCv	MC		RTv	RT
	74	71		50	88
	85	65		75
	82	73		78	100
	87	67		78	72
	67	91		80	100
	67	51		80
	65	56		82
	74	76		86	90
	73	85		91	97
	74	82		93	94
	81	75		94	92
	76	69		95	73
	76	61		100	76
	69	80		100
	74	86
	86	85
	87	75

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>