In the attached workbook click the Run button on Sheet1 to create a list of required unique values in Sheet2- I TRIED IT BUT DUPLICATE VALUE REMAIN I NEED ONLY UNIQUE VALUES TO REMAIN