Use a pivot table.Pivot columns A and B then include a count of either column, this should giveyou a unique list. Finally, copy and paste special the pivot table