Excel and duplicate lines

From:	-Daz-	29 Aug 2006 18:43
To:	ALL	1 of 7

30446.1

I'm currently scanning our network for software installs to make sure we're licence-compliant but I have to do several scans to make sure I get all the laptops that come and go, those that didn't respond because of firewalls etc. which leaves me with several Excel sheets I need to merge with a lot of the same data. Is there an easy way to remove duplicate rows in Excel where /all/ the cells are the same?

I will eventually be databasing the living /shit/ out of it, but it would be far easier for me if I have Excel sheet right before I upload it.

TIA
MIA
BYOB

A Catholic, a Muslim and a Jew walked in to a bar.
What a wonderful example of social integration.

0/0

Reply Quote

More

From:	Peter (BOUGHTONP)	29 Aug 2006 18:47
To:	-Daz-	2 of 7

30446.2 In reply to 30446.1
Data>Filter>Advanced Filter has a "Unique records only" option, but I've never been able to get that to work in a helpful way myself. `3.1415P265E589T932E846R64338`

0/0

Reply Quote

More

From:	-Daz-	29 Aug 2006 18:52
To:	Peter (BOUGHTONP)	3 of 7

30446.3 In reply to 30446.2
Ooooh, sounds promising. Ta. A Catholic, a Muslim and a Jew walked in to a bar. What a wonderful example of social integration.

0/0

Reply Quote

More

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?

0/0

Reply Quote

More

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.

0/0

Reply Quote

More

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. ;) `3.1415P265E589T932E846R64338`

0/0

Reply Quote

More