Hi there, I have been able to do this previously and cannot for the lfie of me remember how I did it.

I have a Spreadsheet set out as following

Sheet 1
Row A1:F1 = Column titles
Row 2 - BLANK (can have information put in columns G and beyond)
A3:A1002 - Names (all entries unique)
B3:D1002 - information about the data
E3:E1002 - Either 1 or 0
F3:F1002 - Currently if E=1, Name else Blank

F can be changed or entirely removed if needs be.

I need to create a drop down box on Sheet 2 that will populate with only those names (from column A) which are available (column E is 1) without blanks.

I'm sure previously I used a formulae to create a list without blanks in column G, used a dynamic named range to create the dropdown. But I cannot remember the formula for column G to populate the list for the dynamic named range.

Any advice?