This could help

Array Formula condenses list then you set your dynamic named range to the new list. This removes duplicates and (all blanks but one). Modify to removed 2nd column IF="yes".

http://www.excelforum.com/excel-form...2-columns.html