Re: Difference between two ranges

From: Jay (anonymous_at_discussions.microsoft.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 04:57:36 -0800

JulieD

Thanks, I know I need to use this, but I am hav a little
dumb moment. Can you possibly send me a working example or
rephrase this:

Extracting Values Common To Two Lists

You can easily extract values that appear in both of two
lists. Suppose your lists are in A1:A10 and B1:B10. Enter
the following array formula in the first cell of the range
which is to contain the common entries:

Extracting Values Common To Two Lists

You can easily extract values that appear in both of two
lists. Suppose your lists are in A1:A10 and B1:B10. Enter
the following array formula in the first cell of the range
which is to contain the common entries:

=IF(COUNTIF($A$1:$A$10,B1)>0,B1,"")

Change B1 and $A$1:$A$10 to the first cells in the
ranges from which data that you want to extract common
items. Then, use Fill Down (from the Edit menu) to fill
the formula down to as many rows as you need to hold the
common entries (i.e., up to as many rows as there are in
the original range.)

>-----Original Message-----
>Hi Jay
>
>Chip Pearson has lots of information on his site for
working with duplicates
>http://www.cpearson.com/excel/duplicat.htm
>
>
>Cheers
>JulieD
>
>"Jay Mandevia" <jay.mandevia@naa.org.uk> wrote in message
>news:02d801c4ce34$2fe7fb10$a501280a@phx.gbl...
>> Hi I would like to know if it is possible in excel to
tell
>> the difference in values between two columns. I know in
>> SQL i can create query to say:
>>
>> select *
>> from table1
>> where id NOT IN (select ID from table2)
>>
>> How can i tell the which row is not in the first column
in
>> excel?
>>
>> Thanks
>
>
>.
>

Relevant Pages

  • Re: Difference between two ranges
    ... >Another frequent tasks involving lists is to create a ... >that you want to extract items. ... >> Extracting Values Common To Two Lists ... >> the following array formula in the first cell of the ...
    (microsoft.public.excel.misc)
  • Re: Cons cell archaic!?
    ... implementing the first Lisp on an IBM 704. ... when you think of lists as sequence of things as ... you will also have functions that extract arbitrary contiguous ... in any other lang), and you must also have functions that do delete ...
    (comp.lang.lisp)
  • Re: Variable-sized lines of text in linked list (long)
    ... My web site server log seemed horribly cluttered and 'hits' from ... log a line at a time and made lists so I ... chronologically by requestor. ... Extract data from a log record to a log element ...
    (comp.lang.c)
  • Re: Family History Software
    ... primitive database program to list my ancestors in one view, ... Note that I didn't have to type in details of the census more than once. ... selection lists for further processing? ... In addition I want to add an extract ...
    (soc.genealogy.britain)
  • Re: PyCheck for a classes defined in python and user data in PyObject_HEAD
    ... in C I want to check if a given PyObject is a xml.dom.minidom.Node (or ... how do i extract a PyTypeObject for such a class? ... I'm in a situation when i don't really need to extend python with any ... object in a key with an obscure name while in lists this would change ...
    (comp.lang.python)