Try:
in "Sheet1"
in A2
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
in B2 (List of UNIQUE orders)
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
in C2
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
" named ranges : "Containers" and "Orders"
in "TSA Request"
in F6
DV
List
=Orders
in F7
DV
list
=Containers
I recommend you look here and understand why your data needs to be reformatted in "normalized" form.
https://support.microsoft.com/en-gb/...ization-basics
For example: if a customer address changes, you have to change many records in your current file. If there was a separate address table, linked by Customer number, then you only change one entry in the "customer" table..
Bookmarks