Spreadsheet: 702832d1604566825-need-help-on-sorting-locations-with-specific-zoning-criteria-help-on-sorting-based-few-criteria
Sheet: Sheet1

04-1A-1-025 |  | Zone Range 2: | A and B |  | Zone Range 1: | 1 - 7 | Desired | 04-1B-3-001
04-1A-1-046 |  |  | C and D |  |  | 8 - 14 | Results: | 04-1B-5-002
04-1A-1-056 |  |  | E and F |  |  | 15 - 21 |  | 04-1B-3-004
04-1A-2-016 |  |  | G and H |  |  | 22 - 28 |  | 04-1B-2-009
04-1A-2-024 |  |  | I and J |  |  | 29 - 35 |  | 04-1B-2-010
04-1A-2-032 |  |  | K and L |  |  | 36 - 42 |  | 04-1A-3-012
04-1A-2-038 |  |  | M and N |  |  | 43 - 49 |  | 04-1B-3-015
04-1A-2-067 |  |  |  |  |  | 50 - 56 |  | 04-1B-4-015
04-1A-3-012 |  |  |  |  |  | 57 - 63 |  | 04-1A-2-016
04-1A-3-021 |  |  |  |  |  | 64 - 70 |  | 04-1A-4-016
04-1A-3-022 |  |  |  |  |  | 71 - 77 |  | 04-1B-2-019
04-1A-3-037 |  |  |  |  |  | 78 - 84 |  | 04-1A-3-021
04-1A-3-048 |  |  |  |  |  |  |  | 04-1A-3-022
04-1A-3-057 | I need to sort Column A, first by the alphabet, |  |  |  |  |  |  | 04-1B-2-023
04-1A-4-016 | with a zone range in column D, |  |  |  |  |  |  | 04-1A-2-024
04-1A-4-035 | then by the zone on the last 2 digit. |  |  |  |  |  |  | 04-1A-1-025
04-1A-4-047 |  |  |  |  |  |  |  | 04-1A-2-032
04-1A-4-069 |  |  |  |  |  |  |  | 04-1A-4-035
04-1B-1-060 |  |  |  |  |  |  |  | 04-1A-3-037
04-1B-1-065 |  |  |  |  |  |  |  | 04-1A-2-038
04-1B-2-009 |  |  |  |  |  |  |  | 04-1A-1-046
04-1B-2-010 |  |  |  |  |  |  |  | 04-1A-4-047
04-1B-2-019 |  |  |  |  |  |  |  | 04-1A-3-048
04-1B-2-023 |  |  |  |  |  |  |  | 04-1B-3-049
04-1B-2-054 |  |  |  |  |  |  |  | 04-1B-2-054
04-1B-3-001 |  |  |  |  |  |  |  | 04-1A-1-056
04-1B-3-004 |  |  |  |  |  |  |  | 04-1A-3-057
04-1B-3-015 |  |  |  |  |  |  |  | 04-1B-1-060
04-1B-3-049 |  |  |  |  |  |  |  | 04-1B-1-065
04-1B-3-068 |  |  |  |  |  |  |  | 04-1A-2-067
04-1B-4-015 |  |  |  |  |  |  |  | 04-1B-3-068
04-1B-5-002 |  |  |  |  |  |  |  | 04-1A-4-069
04-1B-5-027
04-1B-6-039
04-1C-1-011
04-1C-1-014
04-1C-1-023
04-1C-1-040
04-1C-1-045
04-1C-1-064
04-1C-2-019
04-1C-2-021
04-1C-2-056
04-1C-2-060
04-1C-3-002
04-1C-3-031
04-1C-3-045
04-1C-4-009
04-1C-4-023
04-1C-4-024
04-1C-5-001
04-1C-5-017
04-1C-5-027
04-1C-5-028
04-1C-5-028
04-1D-1-039
04-1D-1-059
04-1D-1-068
04-1D-2-014
04-1D-2-053
04-1D-3-016
04-1D-3-031
04-1D-3-033
04-1D-3-037
04-1D-3-040
04-1D-3-061
04-1D-4-037
04-1D-4-044
04-1D-5-024
04-1D-5-038
04-1D-5-060
04-1D-6-013
04-1D-6-037
04-1D-6-038
04-1D-6-040
04-1D-6-041
04-1E-1-013
04-1E-1-013
04-1E-1-024
04-1E-1-043
04-1E-1-053
04-1E-2-015
04-1E-2-015
04-1E-2-015
04-1E-2-016
04-1E-2-017
04-1E-2-028
04-1E-2-052
04-1E-2-054
04-1E-2-058
04-1E-2-058
04-1E-2-059
04-1E-2-060
04-1E-2-062
04-1E-2-070
04-1E-3-002
04-1E-3-006
04-1E-3-006
04-1E-3-008
04-1E-3-013
04-1E-3-013
04-1E-3-013
04-1E-3-013
04-1E-3-015
04-1E-3-015
04-1E-3-016
04-1E-3-016
04-1E-3-027
04-1E-3-033
04-1E-3-043
04-1E-3-066
04-1E-3-070
04-1E-4-005
04-1E-4-009
04-1E-4-033
04-1E-4-045
04-1E-4-048
04-1E-5-029
04-1E-5-037
04-1E-5-050
04-1E-5-068
04-1E-6-035
04-1F-1-005
04-1F-1-009
04-1F-1-009
04-1F-1-014
04-1F-1-014
04-1F-1-016
04-1F-1-017
04-1F-1-018
04-1F-1-018
04-1F-1-040
04-1F-1-065
04-1F-2-001
04-1F-2-001
04-1F-2-001
04-1F-2-001
04-1F-2-002
04-1F-2-002
04-1F-2-002
04-1F-2-003
04-1F-2-003
04-1F-2-003
04-1F-2-003
04-1F-2-003
04-1F-2-003
04-1F-2-003
04-1F-2-004
04-1F-2-004
04-1F-2-004
04-1F-2-004
04-1F-2-004
04-1F-2-005
04-1F-2-005
04-1F-2-005
04-1F-2-006
04-1F-2-006
04-1F-2-006
04-1F-2-007
04-1F-2-007
04-1F-2-008
04-1F-2-008
04-1F-2-009
04-1F-2-010
04-1F-2-011
04-1F-2-012
04-1F-2-014
04-1F-2-015
04-1F-2-017
04-1F-2-017
04-1F-2-027
04-1F-2-028
04-1F-2-029
04-1F-2-030
04-1F-2-031
04-1F-2-033
04-1F-2-034
04-1F-2-039
04-1F-2-056
04-1F-3-001
04-1F-3-028
04-1F-3-039
04-1F-3-064
04-1F-3-065
04-1F-3-067
04-1F-4-015
04-1F-4-020
04-1F-4-025
04-1F-4-045
04-1F-4-069
04-1F-5-019
04-1F-5-027
04-1F-5-036
04-1F-5-048
04-1F-5-064
04-1G-1-001
04-1G-1-020
04-1G-1-021
04-1G-1-022
04-1G-1-023
04-1G-1-032
04-1G-1-039
04-1G-1-059
04-1G-1-060
04-1G-2-002
04-1G-2-008
04-1G-2-028
04-1G-2-029
04-1G-2-032
04-1G-2-032
04-1G-2-036
04-1G-2-054
04-1G-2-058
04-1G-2-058
04-1G-2-059
04-1G-2-059
04-1G-2-060
04-1G-2-061
04-1G-2-061
04-1G-2-062
04-1G-2-062
04-1G-3-013
04-1G-3-016
04-1G-3-017
04-1G-3-020
04-1G-3-061
04-1G-3-064
04-1G-3-064
04-1G-3-066
04-1G-3-067
04-1G-3-067
04-1G-4-004
04-1G-4-025
04-1G-4-027
04-1G-4-028
04-1G-4-030
04-1G-4-032
04-1G-4-034
04-1G-4-034
04-1G-4-035
04-1G-4-035
04-1G-4-048
04-1G-4-056
04-1G-4-065
04-1G-4-068
04-1G-4-069
04-1G-5-020
04-1G-5-023
04-1G-5-028
04-1G-5-032
04-1G-5-054
04-1G-5-055
04-1G-5-056
04-1G-5-057
04-1G-5-066
04-1G-5-067
04-1G-5-069
04-1G-5-070
04-1G-6-032
04-1G-6-037
04-1H-1-007
04-1H-1-021
04-1H-1-038
04-1H-2-001
04-1H-2-047
04-1H-2-049
04-1H-2-053
04-1H-2-055
04-1H-2-059
04-1H-2-059
04-1H-2-060
04-1H-2-062
04-1H-2-062
04-1H-2-062
04-1H-2-063
04-1H-2-064
04-1H-3-008
04-1H-3-012
04-1H-3-029
04-1H-3-030
04-1H-3-033
04-1H-3-043
04-1H-3-046
04-1H-3-056
04-1H-3-064
04-1H-3-065
04-1H-4-028
04-1H-4-029
04-1H-4-034
04-1H-4-047
04-1H-4-047
04-1H-4-056
04-1H-4-067
04-1H-4-068
04-1H-4-069
04-1H-5-026
04-1H-5-030
04-1H-5-044
04-1H-5-048
04-1H-5-051
04-1H-5-056
04-1H-5-070
04-1H-6-068
04-1I-1-026
04-1I-1-027
04-1I-1-030
04-1I-1-042
04-1I-1-046
04-1I-1-050
04-1I-1-057
04-1I-1-058
04-1I-1-064
04-1I-2-010
04-1I-2-013
04-1I-2-014
04-1I-2-022
04-1I-2-033
04-1I-2-038
04-1I-2-038
04-1I-2-040
04-1I-2-040
04-1I-2-041
04-1I-2-041
04-1I-2-041
04-1I-2-042
04-1I-2-042
04-1I-2-042
04-1I-2-042
04-1I-2-043
04-1I-2-044
04-1I-2-048
04-1I-3-007
04-1I-3-012
04-1I-3-015
04-1I-3-017
04-1I-3-017
04-1I-3-018
04-1I-3-018
04-1I-3-020
04-1I-3-025
04-1I-3-026
04-1I-3-032
04-1I-3-034
04-1I-3-038
04-1I-3-043
04-1I-3-044
04-1I-3-049
04-1I-4-002
04-1I-4-027
04-1I-4-034
04-1I-4-070
04-1I-5-012
04-1I-5-019
04-1I-5-032
04-1I-5-047
04-1I-6-019
04-1I-6-034
04-1I-6-058
04-1J-1-021
04-1J-1-045
04-1J-1-048
04-1J-1-063
04-1J-2-006
04-1J-2-024
04-1J-2-035
04-1J-2-051
04-1J-2-052
04-1J-2-052
04-1J-2-057
04-1J-2-063
04-1J-3-006
04-1J-3-027
04-1J-3-033
04-1J-3-034
04-1J-3-035
04-1J-3-040
04-1J-4-012
04-1J-4-017
04-1J-4-020
04-1J-4-028
04-1J-4-035
04-1J-4-043
04-1J-4-045
04-1J-4-046
04-1J-4-052
04-1J-4-054
04-1J-4-067
04-1J-5-016
04-1J-5-018
04-1J-5-021
04-1J-5-022
04-1J-5-028
04-1J-5-046
04-1J-5-055
04-1J-5-056
04-1J-5-057
04-1J-5-057
04-1J-5-058
04-1J-5-059
04-1J-5-070
04-1J-6-011
04-1J-6-015
04-1J-6-030
04-1J-6-030
04-1J-6-034
04-1J-6-034
04-1J-6-036
04-1J-6-037
04-1J-6-054
04-1K-1-003
04-1K-1-004
04-1K-1-028
04-1K-1-035
04-1K-1-037
04-1K-1-041
04-1K-1-062
04-1K-2-003
04-1K-2-003
04-1K-2-017
04-1K-2-036
04-1K-2-050
04-1K-2-050
04-1K-2-050
04-1K-2-050
04-1K-2-051
04-1K-2-052
04-1K-2-053
04-1K-2-054
04-1K-2-054
04-1K-2-054
04-1K-2-055
04-1K-2-055
04-1K-2-055
04-1K-2-056
04-1K-3-012
04-1K-3-013
04-1K-3-018
04-1K-3-028
04-1K-3-030
04-1K-3-030
04-1K-3-031
04-1K-3-031
04-1K-3-035
04-1K-3-036
04-1K-3-036
04-1K-3-037
04-1K-3-038
04-1K-3-041
04-1K-3-051
04-1K-3-059
04-1K-4-005
04-1K-4-013
04-1K-4-024
04-1K-4-027
04-1K-4-027
04-1K-4-031
04-1K-4-032
04-1K-4-033
04-1K-4-037
04-1K-4-043
04-1K-4-048
04-1K-4-058
04-1K-5-017
04-1K-5-029
04-1K-5-035
04-1K-5-037
04-1K-5-038
04-1K-5-043
04-1K-6-016
04-1K-6-029
04-1K-6-036
04-1L-1-001
04-1L-1-028
04-1L-1-031
04-1L-1-031
04-1L-1-054
04-1L-2-009
04-1L-2-048
04-1L-2-049
04-1L-2-049
04-1L-2-049
04-1L-2-050
04-1L-2-063
04-1L-3-013
04-1L-3-018
04-1L-3-049
04-1L-4-010
04-1L-4-045
04-1L-4-048
04-1L-4-049
04-1L-5-003
04-1L-5-008
04-1L-5-014
04-1L-5-037
04-1L-5-051
04-1L-6-019
04-1L-6-020
04-1L-6-020
04-1L-6-024
04-1L-6-027
04-1L-6-034
04-1L-6-045
04-1M-1-007
04-1M-1-011
04-1M-1-013
04-1M-1-016
04-1M-1-022
04-1M-1-027
04-1M-2-031
04-1M-2-031
04-1M-2-031
04-1M-2-032
04-1M-2-034
04-1M-2-048
04-1M-2-064
04-1M-2-065
04-1M-2-067
04-1M-2-068
04-1M-2-070
04-1M-3-019
04-1M-3-046
04-1M-4-028
04-1M-4-046
04-1M-4-047
04-1M-4-055
04-1M-4-060
04-1M-5-008
04-1M-5-017
04-1M-5-036
04-1M-5-052
04-1M-5-067
04-1M-6-029
04-1M-6-036
04-1M-6-037
04-1M-6-046
04-1M-6-047
04-1M-6-052
04-1M-6-067
04-1N-1-016
04-1N-1-017
04-1N-1-032
04-1N-1-035
04-1N-1-043
04-1N-1-055
04-1N-1-061
04-1N-1-062
04-1N-2-018
04-1N-2-033
04-1N-2-034
04-1N-2-037
04-1N-2-038
04-1N-2-039
04-1N-2-045
04-1N-2-046
04-1N-2-046
04-1N-2-049
04-1N-2-050
04-1N-2-051
04-1N-2-064
04-1N-2-064
04-1N-2-066
04-1N-2-066
04-1N-3-010
04-1N-3-021
04-1N-3-026
04-1N-3-034
04-1N-3-050
04-1N-3-051
04-1N-4-005
04-1N-4-007
04-1N-4-027
04-1N-4-031
04-1N-4-031
04-1N-4-033
04-1N-4-034
04-1N-4-039
04-1N-4-041
04-1N-4-041
04-1N-4-046
04-1N-4-069
04-1N-4-070
04-1N-4-070
04-1N-5-009
04-1N-5-017
04-1N-5-031
04-1N-5-032
04-1N-5-033
04-1N-5-064
04-1N-5-065
04-1O-1-046
04-1O-1-059
04-1O-2-002
04-1O-2-005
04-1O-2-008
04-1O-2-015
04-1O-2-019
04-1O-2-027
04-1O-2-036
04-1O-2-040
04-1O-2-046
04-1O-3-011
04-1O-3-011
04-1O-3-014
04-1O-3-017
04-1O-3-039
04-1O-3-041
04-1O-3-046
04-1O-3-061
04-1O-3-066
04-1O-3-066
04-1O-3-069
04-1O-3-069
04-1O-3-070
04-1O-3-070
04-1O-4-022
04-1O-4-024
04-1O-4-027
04-1O-4-050
04-1O-4-050
04-1O-4-051
04-1O-4-052
04-1O-4-053
04-1O-4-054
04-1O-4-055
04-1O-4-055
04-1O-4-055
04-1O-4-056
04-1O-4-056
04-1O-5-069