LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Regarding Duplicates

Hi All,

How are u? i have a small query about find the missed numbers in two
different lists.

List A list B
1 1
2 5
3 6
6 7
9 8
4 3
7 10
14 9
5 20
10 17
15 14
12 13
13
8
11

I want to find numbers which is not in "list A", Which is in "List B".
in the above example 17 and 20 are the volumes which is not in "List
A" and is there in "List B". i need all new arrived number in one more
list.


Thanks and Regards,
Anil.
 
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
Condensing a list with duplicates to a list with non-duplicates Nuclear Excel Worksheet Functions 2 July 29th 08 08:03 PM
Duplicates wynand Excel Discussion (Misc queries) 2 May 22nd 08 01:24 PM
Duplicates in excel that aren't 100% DUPLICATES ... [email protected] Excel Discussion (Misc queries) 4 May 2nd 08 06:43 PM
Duplicates Krissie C Excel Discussion (Misc queries) 3 November 16th 05 01:17 PM
Duplicates Steved Excel Worksheet Functions 2 August 25th 05 10:58 AM


All times are GMT +1. The time now is 08:26 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"