Finding Duplicate Data In Excel 2000
 

I am trying to find a way to Find and Group duplicate data in an Excel
spreadsheet. Is there a way to do this?
--
Jchambers

Finding Duplicate Data In Excel 2000
 

You could sort by the key field/column.

Then use some of the techniques at Chip Pearson's site:
http://www.cpearson.com/excel/Duplicates.aspx


Jchambers wrote:

I am trying to find a way to Find and Group duplicate data in an Excel
spreadsheet. Is there a way to do this?
--
Jchambers

--

Dave Peterson

Finding Duplicate Data In Excel 2000
 

I have tried that. I would like to Be able to query multiple columns and
still have the all of the information in the row associated with the findings.

--
Jchambers


"Dave Peterson" wrote:

You could sort by the key field/column.

Then use some of the techniques at Chip Pearson's site:
http://www.cpearson.com/excel/Duplicates.aspx


Jchambers wrote:

I am trying to find a way to Find and Group duplicate data in an Excel
spreadsheet. Is there a way to do this?
--
Jchambers

--

Dave Peterson

Finding Duplicate Data In Excel 2000
 

Maybe just using data|filter|autofilter on the key field would be sufficient.

Jchambers wrote:

I have tried that. I would like to Be able to query multiple columns and
still have the all of the information in the row associated with the findings.

--
Jchambers

"Dave Peterson" wrote:

You could sort by the key field/column.

Then use some of the techniques at Chip Pearson's site:
http://www.cpearson.com/excel/Duplicates.aspx


Jchambers wrote:

I am trying to find a way to Find and Group duplicate data in an Excel
spreadsheet. Is there a way to do this?
--
Jchambers

--

Dave Peterson


--

Dave Peterson