2 May 2006 at 15:59 #1 The_KiD The_KiD Permabanned Joined 19 Apr 2006 Posts 2,333 Location West Yorkshire Right I have an excel sheet, which is one column with a load of web addresses in. Is there anything I can run or do to automatically run through it and remove any duplicate's ?
Right I have an excel sheet, which is one column with a load of web addresses in. Is there anything I can run or do to automatically run through it and remove any duplicate's ?
2 May 2006 at 16:06 #2 div0 div0 Soldato Joined 12 Jan 2006 Posts 4,571 Location Edinburgh Select the column - click Data - Filter - Advanced Filter - (make sure selected range highlighted is correct) - click "unique records only" Done
Select the column - click Data - Filter - Advanced Filter - (make sure selected range highlighted is correct) - click "unique records only" Done
2 May 2006 at 16:23 #3 The_KiD The_KiD Permabanned OP Joined 19 Apr 2006 Posts 2,333 Location West Yorkshire dude I love you
2 May 2006 at 16:29 #4 div0 div0 Soldato Joined 12 Jan 2006 Posts 4,571 Location Edinburgh sssshhh dont tell everyone they'll get jealous
