Hi all,
I have attached a screenshot that i think shows everything I will now try to explain more below.
EF SG1.png
I have Tbl_Comp3 which I have referenced in my UNIQUE formula in cell E2
This has given me the dynamic list I am after
I wish to use this list as a Data Validation list but, as you can see, it doesn't find anything to put into the 'Value' field.
What am I missing?
Bookmarks