Jtucker10278
Board Regular
- Joined
- May 14, 2017
- Messages
- 56
so I have a spread sheet that has
<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
<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>
<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>
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