Dynamic Dependent List - Data Validation

Afternoon,

Looking for 2 data validation formulas for:

1. Drop down menu (E2) to list only distinct values from "Agency" column. E2 drop down menu should adjust dynamically as more Agency names are added to column A.
2. Drop down menu (G2) to list only distinct values from "Sites" column AND dependent on E2 selection. So if "Kepler Specialist" selected in E2, only "Daufny Day Program" and "Art and Foods" should be listed in drop down. Of course blanks should be ignored....

thanks