Ah Yes, thank you so much
Lastly do you know how to take off that highlighted text & cell after founding all the duplicates.
Also when i went inside the duplicate value i see that the default value is duplicate, but i see another value called "unique" do you know what that is, perhaps in the future i might find it useful.