Unique Values in Dynamic Down List

Originally Posted by Bo_Ry

Please try at
F17
=IFERROR(INDEX(OffersTable3[Offer],SMALL(IF(FREQUENCY(IF(OffersTable3[Region]=$F$16,MATCH(OffersTable3[Offer],OffersTable3[Offer],)),ROW(OffersTable3)-ROW(A$1)),ROW(OffersTable3)-ROW(A$1)),ROWS(F$17:F17))),"")
Press Ctrl+Shift+Enter and drag down

Data Validation list
=OFFSET($F$17,,,COUNTIF($F$17:$F$27,"?*"))

Bo_Ry - thanks for responding but for some reason it only works when "East" is selected. If North, South or West is entered in F16, there are blanks in F17 on and some of the Offers entries are missing. There aren't any blanks in the table so I'm curious how those are being returned.