i have a large list of urls in excel. how do i sort the urls in alphabetical order then remove the duplicates, thanks
i have a large list of urls in excel. how do i sort the urls in alphabetical order then remove the duplicates, thanks
not sure what version of excel the "excel starte" is, so hopefully this will work for you. hightlight the range you are working with, right=click and select data/sort, a-z. then while the range is still high-lighted, go do data and select "remove duplicates"
let me know how that works for you?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks