Reply to All
Show messages
Messages
Inbox
Search
Login
1–7
Excel and duplicate lines
From: Extrobe (ALDREDD)
29 Aug 2006 21:30
To: -Daz-
4 of 7
30446.4
In reply to
30446.1
if you can get your mitts on excel 2007, it has a button called 'remove duplicates' which 'removes duplicate rows from a sheet'. Might do the trick?
From: ian
29 Aug 2006 21:32
To: -Daz-
5 of 7
30446.5
In reply to
30446.3
I tried to do something like that with Excel and did something like what Peter says, except the filter doesn't delete anything it just hides them.
The only way I could actually
delete
the duplicates was to do the filter then copy and paste the result into another spreadsheet, which seemed kinda gay. But then maybe I was doing it wrong.
From: Peter (BOUGHTONP)
29 Aug 2006 21:41
To: ian
6 of 7
30446.6
In reply to
30446.5
quote:
But then maybe I was doing it wrong.
Tut tut.
Rule of Computing #11: Never blame yourself when Microsoft software is involved.
;)
Message 30446.7 was deleted