LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to eliminate 0's Dani B Excel Discussion (Misc queries) 3 December 18th 08 04:20 PM
Duplicates in excel that aren't 100% DUPLICATES ... [email protected] Excel Discussion (Misc queries) 4 May 2nd 08 06:43 PM
Eliminate duplicates in mailing list AnneCir Excel Discussion (Misc queries) 7 April 4th 07 11:58 PM
Eliminate Duplicates in Pivot Table roadkill Excel Discussion (Misc queries) 2 February 3rd 06 06:13 PM
Pivot Table- how do I eliminate duplicates in count of name Isabelga Excel Discussion (Misc queries) 1 January 16th 06 06:15 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"