I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
records only"
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <[email protected]> wrote in message
news:[email protected]...
>I have a large list of noames that I need to make sure that none of them
>are
> duplicated. Is there a way to have excel check it quisker than me reading
> every name until I find a duplicate?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks