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 Eliminating duplicated data completely or something similar

Say I have 2 lists. One of which we'll call citizens, the other we'll call
enemies. everyone on the citizens list should also be included in the Enemies
list, but they're not. I'm trying to have it list the names that do not show
on the enemies list. How would I go about doing this? Is it an INDEX function
or a MATCH function? Been tearing my hair out on this one. Thanks!
 
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 compare similar entries, NOT duplicated ones? Serapk New Users to Excel 3 January 7th 09 03:51 PM
How can I delete duplicated data tweacle[_5_] Excel Worksheet Functions 1 December 20th 07 12:59 AM
duplicated external data dany Excel Discussion (Misc queries) 1 March 21st 07 08:13 AM
Duplicated data Louise Excel Worksheet Functions 3 July 1st 05 01:36 PM
Eliminating data repitition Graham Excel Discussion (Misc queries) 1 June 8th 05 03:26 PM


All times are GMT +1. The time now is 06:39 AM.

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"