Need some help on dynamic dropdow for filtered row or for visible rows only

HI

Can we have a conditional list in excel where it show only active cell (Visualized cells) in the list (After applying filter) .