I now have a compilation of around 3,500 rows each with 6 rows. Some of the subject matter that im organzing Ive noticed has been duplicated 2,3 and even sometimes 4 times by the person who provided it leaving me with several cells that are duplicates of eachother.
Is there a way to quickly get rid of all the duplicates?
Can you use the Advanced filter on the data menu to filter unique cells only (based on one of the columns) and extract them to another worksheet?
R
I tried doing the advanced filter, click unqique only and left it in place and it didnt do anything...it told me how many there were but i need the extras deleted
I still need help if anyone could help x.x
thanks ruthki i eventually got it ^_^
Last edited by hottxboi16; 10-25-2006 at 02:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks