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