Spreadsheet: 109347d1306245659-create-dynamic-list-with-3-criteria-example
Sheet: Sheet1

Index | ELR | Access Point Name | Mileage |  | 100 | SPC1 | 4.044 | 7.0704
1 | SPC1 | [NAME] | 0.0561 |  |  | [NAME]
2 | SPC1 | Camley Street | 0.099 |  |  | Camley Street |  |  |  | End Mileage Specified from other sheet (miles and yards)
3 | SPC1 | [NAME] | 0.135 |  |  | [NAME] |  |  |  | Start Mileage specified from other sheet (miles and yards)
4 | SPC1 | Regis Road | 1.1067 |  |  | Regis Road
5 | SPC1 | Kentish Town Junction | 1.1119 |  |  | Kentish Town Junction
6 | SPC1 | Belsize Tunnel North Portal | 2.0726 |  |  | Belsize Tunnel North Portal |  |  |  | ELR Value isactually from another sheet selected by user
7 | SPC1 | West Hampstead South Junction | 3.1071 |  |  | West Hampstead South Junction
8 | SPC1 | Finchley Road | 3.11 |  |  | Finchley Road
9 | SPC1 | West Hampstead Psb | 3.1723 |  |  | West Hampstead Psb
10 | SPC1 | Watling Street Jcn (Westcroft Close) | 4.1108 |  |  | Watling Street Jcn (Westcroft Close)
11 | SPC1 | [NAME] UB40 | 5.0099 |  |  | [NAME] UB40 |  |  |  | So using data values above, the expected returned dynamic list would only show 'Access Points Names' between the two given mileages i.e
12 | SPC1 | Cricklewood Sidings Walking Route | 5.0198 |  |  | Cricklewood Sidings Walking Route
13 | SPC1 | Cricklewood Station North | 5.0418 |  |  | Cricklewood Station North
14 | SPC1 | Cricklewood Depot | 5.043 |  |  | Cricklewood Depot
15 | SPC1 | Post Office Sidings | 5.1344 |  |  | Post Office Sidings
16 | SPC1 | Cricklewood Depot S/Box And Sidings | 5.1498 |  |  | Cricklewood Depot S/Box And Sidings |  |  |  | Watling Street Jcn (Westcroft Close)
17 | SPC1 | Cricklewood Sidings Vehicle Access Route | 5.174 |  |  | Cricklewood Sidings Vehicle Access Route |  |  |  | [NAME] UB40
18 | SPC1 | Pc World | 6.044 |  |  | Pc World |  |  |  | Cricklewood Sidings Walking Route
19 | SPC1 | Brent Park Road - U/B No. 44 | 6.077 |  |  | Brent Park Road - U/B No. 44 |  |  |  | Cricklewood Station North
20 | SPC1 | Busy Bees (Park Road) | 6.0896 |  |  | Busy Bees (Park Road) |  |  |  | Cricklewood Depot
21 | SPC1 | Hendon Station Car Park | 7.003 |  |  | Hendon Station Car Park |  |  |  | Post Office Sidings
22 | SPC1 | Hendon Station | 7.003 |  |  | Hendon Station |  |  |  | Cricklewood Depot S/Box And Sidings
23 | SPC1 | American Embassy | 7.0137 |  |  | American Embassy |  |  |  | Cricklewood Sidings Vehicle Access Route
24 | SPC1 | Hinges Bridge Footpath - U/B No. 51A | 7.1584 |  |  | Hinges Bridge Footpath - U/B No. 51A |  |  |  | Pc World
25 | SPC1 | Aerodrome Road Silkstream | 7.1606 |  |  | Aerodrome Road Silkstream |  |  |  | Brent Park Road - U/B No. 44
26 | SPC1 | [NAME]. 52A | 7.1606 |  |  | [NAME]. 52A |  |  |  | Busy Bees (Park Road)
27 | SPC1 | Battle Of Britain | 8.0607 |  |  | Battle Of Britain |  |  |  | Hendon Station Car Park
28 | SPC1 | Bunns Lane | 8.1254 |  |  | Bunns Lane |  |  |  | Hendon Station
29 | SPC1 | [NAME] | 8.1269 |  |  | [NAME] |  |  |  | American Embassy
30 | SPC1 | [NAME] | 9.075 |  |  | [NAME]
31 | SPC1 | [NAME] | 9.0756 |  |  | [NAME]
32 | SPC1 | Selvage Lane | 9.172 |  |  | Selvage Lane
33 | SPC1 | Scratchwood Services (Security Barrier) | 10.044 |  |  | Scratchwood Services (Security Barrier)
34 | SPC1 | Scratchwood Services (Hotel) | 10.1255 |  |  | Scratchwood Services (Hotel)
35 | SPC1 | Springwood Cottages | 10.155 |  |  | Springwood Cottages
36 | SPC1 | M1 Maintenance Depot | 11.015 |  |  | M1 Maintenance Depot
37 | SPC1 | Motorway Tip Roadway Underbridge | 11.0572 |  |  | Motorway Tip Roadway Underbridge
38 | SPC1 | Elstree Station Car Park | 12.1042 |  |  | Elstree Station Car Park
39 | SPC1 | Red Road Bridge | 12.1606 |  |  | Red Road Bridge
40 | SPC1 | [NAME] | 13.114 |  |  | [NAME]
41 | SPC1 | Horses Field | 14.0614 |  |  | Horses Field
42 | SPC1 | Dumbletons Bridge - U/B No. 81 | 14.0628 |  |  | Dumbletons Bridge - U/B No. 81
43 | SPC1 | Bagnalls Bridge Ob84 [NAME] | 14.165 |  |  | Bagnalls Bridge Ob84 [NAME]
44 | SPC1 | Track Access At T.S.C. | 15 |  |  | Track Access At T.S.C.
45 | SPC1 | [NAME] | 15.013 |  |  | [NAME]
46 | SPC1 | Shenley Road B462 - O/B No. 85 | 15.0264 |  |  | Shenley Road B462 - O/B No. 85
47 | SPC1 | [NAME] | 15.039 |  |  | [NAME]
48 | SPC1 | [NAME] | 15.044 |  |  | [NAME]
49 | SPC1 | [NAME] <Car Park> | 15.0755 |  |  | [NAME] <Car Park>
50 | SPC1 | [NAME]91 | 16.033 |  |  | [NAME]91
51 | SPC1 | North Obital Trading Estate | 16.088 |  |  | North Obital Trading Estate
52 | SPC1 | Old Parkbury Lane Gun Club - O/B No. 93 | 16.1496 |  |  | Old Parkbury Lane Gun Club - O/B No. 93
53 | SPC1 | [NAME] | 18.1672 |  |  | [NAME]
54 | SPC1 | London Road | 19.0668 |  |  | London Road
55 | SPC1 | St Albans Station Car Park | 19.126 |  |  | St Albans Station Car Park
56 | SPC1 | St Alnans Signalbox | 19.132 |  |  | St Alnans Signalbox
57 | SPC1 | St Albans Station - Up Fast | 19.1442 |  |  | St Albans Station - Up Fast
58 | SPC1 | St Albans City Station | 19.1548 |  |  | St Albans City Station
59 | SPC1 | St Albans City Station - F/B No. 101B | 19.1585 |  |  | St Albans City Station - F/B No. 101B
60 | SPC1 | St Albans Station - Up Slow | 19.175 |  |  | St Albans Station - Up Slow
61 | SPC1 | York Road St Albans-Up Slow | 20.0368 |  |  | York Road St Albans-Up Slow
62 | SPC1 | [NAME] 104 | 20.0638 |  |  | [NAME] 104
63 | SPC1 | [NAME] 105 | 20.088 |  |  | [NAME] 105
64 | SPC1 | Sandridge Road Industrial Estate | 21.048 |  |  | Sandridge Road Industrial Estate
65 | SPC1 | Gryphon Industrial Estate | 21.088 |  |  | Gryphon Industrial Estate
66 | SPC1 | [NAME] | 21.1366 |  |  | [NAME]
67 | SPC1 | Ub108 Sandbridgebury [NAME], Willy Allendales Bridge | 21.1386 |  |  | Ub108 Sandbridgebury [NAME], Willy Allendales Bridge
68 | SPC1 | Sandridgebury Farm Ob109 Cheapside | 22.044 |  |  | Sandridgebury Farm Ob109 Cheapside
69 | SPC1 | Ayres End Lane - O/B 110 | 23.0088 |  |  | Ayres End Lane - O/B 110
70 | SPC1 | Cross [NAME]. 112 | 23.0858 |  |  | Cross [NAME]. 112
71 | SPC1 | [NAME] 113 | 23.1628 |  |  | [NAME] 113
72 | SPC1 | [NAME] | 24.0602 |  |  | [NAME]
73 | SPC1 | Harpenden Station Car Park | 24.1017 |  |  | Harpenden Station Car Park
74 | SPC1 | Harpenden Station Footbridge - O/B No. 117 | 24.1166 |  |  | Harpenden Station Footbridge - O/B No. 117
75 | SPC1 | Harpenden Station | 24.1166 |  |  | Harpenden Station
76 | SPC1 | Harpenden Footbridge Ob119-Up Slow | 24.154 |  |  | Harpenden Footbridge Ob119-Up Slow
77 | SPC1 | [NAME] 121 | 25.0506 |  |  | [NAME] 121
78 | SPC1 | Westfield Road | 25.0761 |  |  | Westfield Road
79 | SPC1 | Ub123 [NAME], Cooters [NAME] | 26.0968 |  |  | Ub123 [NAME], Cooters [NAME]
80 | SPC1 | [NAME] Viaduct - U/B 125A | 26.1452 |  |  | [NAME] Viaduct - U/B 125A
81 | SPC1 | Chiltern Green Cottages | 27.0516 |  |  | Chiltern Green Cottages
82 | SPC1 | Underbridge No. 128 Copthall Road | 27.1474 |  |  | Underbridge No. 128 Copthall Road
83 | SPC1 | Soneries [NAME]. 130 | 28.1276 |  |  | Soneries [NAME]. 130
84 | SPC1 | [NAME] | 28.163 |  |  | [NAME]
85 | SPC1 | [NAME] | 28.164 |  |  | [NAME]
86 | SPC1 | Kimpton Road, [NAME] | 29.0502 |  |  | Kimpton Road, [NAME]
87 | SPC1 | Crescent Road Sidings | 30.0138 |  |  | Crescent Road Sidings
88 | SPC1 | [NAME]. 134 | 30.0157 |  |  | [NAME]. 134
89 | SPC1 | Nv 30M 332Yds | 30.0332 |  |  | Nv 30M 332Yds
90 | SPC1 | Np 30M 349Yds | 30.0349 |  |  | Np 30M 349Yds
91 | SPC1 | [NAME] | 30.0431 |  |  | [NAME]
92 | SPC1 | [NAME] | 30.058 |  |  | [NAME]
93 | SPC1 | [NAME] | 30.0916 |  |  | [NAME]
94 | SPC1 | Moor Path | 30.099 |  |  | Moor Path
95 | SPC1 | [NAME],[NAME], [NAME] | 30.1144 |  |  | [NAME],[NAME], [NAME]
96 | SPC1 | [NAME] 139 The Green Door | 30.1408 |  |  | [NAME] 139 The Green Door
97 | SPC1 | Conservative Club | 31.002 |  |  | Conservative Club
98 | SPC1 | [NAME]140 | 31.033 |  |  | [NAME]140
99 | SPC1 | Limbury Sidings | 31.1241 |  |  | Limbury Sidings
100 | SSJ1 | Sheet Stores Junction | 119.1483 |  |  | #N/A
101 | SSJ1 | Underbridge [NAME] | 121.02
102 | SSJ1 | Underbridge No.9 | 121.0638
103 | SSJ1 | Whites Farm Crossing | 121.08
104 | SSJ1 | Overbridge No.9A | 121.154
105 | SSJ1 | Overbridge No.10 [NAME] | 122.044
106 | SSJ1 | Overbridge No.11 | 122.1562
107 | SSJ1 | Overbridge [NAME] | 123.066
108 | SSJ1 | Trent Lane Industrial Estate | 123.09
109 | SSJ1 | Back Lane Level Crossing | 123.1496
110 | SSJ1 | Tt399 | 123.1698
111 | SSJ1 | Gate 16 Castle Donnington | 124.098
112 | SSJ1 | Underbridge No.16 | 125.064
113 | SSJ1 | Cottons Farm | 125.064
114 | SSJ1 | Weston Old Station Yard | 126.048
115 | SSJ1 | Dy334 | 126.1413
116 | SSJ1 | Overbridge No.24 | 126.143
117 | SSJ2 | Chessaston Jcn | 128
118 | SSJ2 | Ub7A Pringle Lane Swarkestone | 128.083
119 | SSJ2 | Dy344 | 128.088
120 | SSJ2 | Overbridge No. 6 [NAME] | 128.152
121 | SSJ2 | Dy345 | 128.16
122 | SSJ2 | Overbridge No. 5 [NAME] | 129.092
123 | SSJ2 | Overbridge No. 4 Depton Bridge | 129.162
124 | SSJ2 | Overbridge No.3 [NAME] | 130.142
125 | SSJ2 | [NAME] No.2 Stenson Bridge Stenson Road | 131.0792
126 | SSJ2 | Overbridge No.1 Watsons Bridge | 131.13
127 | SSJ2 | Stenson Jcn | 132.0294
128 | TCC | [NAME] | 119.166
129 | TCC | Co-Op Long Eaton | 120.135
130 | TCC | Asda Long Eaton | 121
131 | TCC | [NAME] Via Bessell Lane | 121.144
132 | TCC | Stanton Gate Sf | 123.143
133 | TCC | Ob 32A Shipley Gate Long Lane | 128.088
134 | TCC | Heanor Bungalows | 129.077
135 | TCC | [NAME] | 129.1553
136 | TCC | [NAME] | 129.1648
137 | TCC | [NAME] 44 | 131.0795
138 | TCC | Overbridge No.47 | 132.11
139 | TCC | Codnor Park Junction | 132.1672
140 | TCC | Ub 53-54 Codnor <Slope> | 133.007
141 | TCC | Pye Bridge Station | 133.1051
142 | TCC | [NAME] | 134.0884
143 | TCC | [NAME] | 134.1012
144 | TCC | [NAME] | 136.0154
145 | TCC | Underbridge No. 68 Westhouses <Station> | 137.0196
 | SPC1
 | SSJ1
 | SSJ2
 | TCC