Hi,

Highlight your rows...then

Go to

DATA>>Filter>>Advanced Filter, and then select "UNIQUE RECORDS ONLY"

press OK.