This shows you how to use the unique/sort function to extract a unique list of entries for a dropdown list combined with the Filter() function to extract records that meet certain criteria
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.