Hey all,
I have the following problem which I hope someone may be able to support with?! I have a list of locations in A-Z assigned to an Area Example from Cell E1 and F1 downwards...
<tbody>
</tbody>
What I'm looking to do is in cell B1 have a box where when you enter an Area number it will return all the locations in A-Z from Cell B2 downwards. The issue I have is there are over 300 locations all assigned to Areas 1-22 and I can't seem to get it to just grab the locates to the area number and keep them A-Z
Hope that makes sense
Cheers
S
I have the following problem which I hope someone may be able to support with?! I have a list of locations in A-Z assigned to an Area Example from Cell E1 and F1 downwards...
| 1 | Aberdeen |
| 2 | Ashford |
| 1 | Aberdeen II |
<tbody>
</tbody>
What I'm looking to do is in cell B1 have a box where when you enter an Area number it will return all the locations in A-Z from Cell B2 downwards. The issue I have is there are over 300 locations all assigned to Areas 1-22 and I can't seem to get it to just grab the locates to the area number and keep them A-Z
Hope that makes sense
Cheers
S
