View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jtpryan jtpryan is offline
external usenet poster
 
Posts: 4
Default How to eliminate everything but duplicates

I have a spreadsheet with 2755 rows and columns A--N in it. 2 of
the columns are for first name and last name. I want to take all the
rows that have a matching first name and last name combination and
move them to either another sheet or somewhere else on this sheet. In
other words, isolate them. It is more difficult then it appears at
first.


Thanks for any help.

-Jim