Duplicate Rows in Excel

[tweeter007]

Hey,
I am trying filter duplicate rows in a spreadsheet. I need to have more than just one column, the entire row is important. I guess I am looking for a script or something to check each cell in the row to see if its all the same.

Thanks,
Josh

 

[royweb]

May be it's easier to just import the data into MS Access and create a "duplicates query.

 

[SkipVought]

Hi,

How many columns to check?

Skip,
[sub]
[red][/red]
[/sub]

 

[AnotherHiggins]

Data > Filter > Advanced Filter, tick the box at the bottom next to Unique records only.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[tweeter007]

There are six columns of information.
Advanced Filter doesnt let me choose all of the columns. Is there certain data that doesnt let me filter.
josh

 

[AnotherHiggins]

Advanced Filter > Unique records only will look across all selected columns to decide whether a record is a duplicate or not.

Clicking on any cell in the data set and choosing Advanced Filter will select all contiguous cells. If you have empty columns in your data set, you will need to either remove the columns (I'd suggest this) or select all of the data before selecting Data.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[tweeter007]

I'll give it a shot.
Thanks.