RE: Very easy question about filter!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

>From Chip Pearson's website:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
---------------------------------------------
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.)
---------------------------------------------

BTW, to enter an array, type in the formula then hit Ctrl-Shift-Enter.

When you get a chance, you should check out Chip's full site at...
http://www.cpearson.com/
HTH,
--
Gary Brown
gary_brown@xxxxxxxxxxxxx
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"Wilmarjr" wrote:

>
> Hi guys,
>
> I am trying to do something that looks simple but I can't figure out.
> I am trying to copy for a third column the names that match from the
> first two columns. for example:
>
> 1º column 2º column
> Nina john
> john Ryan
> smith Sherry
> bob chuck
> carlos bob
> chuck sam
> andrea
>
> I would like to have a third column if john, chuck and bob's name.
> If somebody have this info, please let me know.
> thanks, Will
>
>
> --
> Wilmarjr
> ------------------------------------------------------------------------
> Wilmarjr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23609
> View this thread: http://www.excelforum.com/showthread.php?threadid=382552
>
>
.

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: duplicates
    ... Extracting Values Common To Two Lists ... You can easily extract values that appear in both of two lists. ... an array formula needs to be committed with control & ...
    (microsoft.public.excel.programming)
  • Re: vlookup
    ... > vlookup ISN'T used to extract values common to two lists, ... > is on extracting values common to two lists, ... >> I want to be able to use lookup to extract values common to two list. ...
    (microsoft.public.excel.newusers)
  • Re: vlookup
    ... is on extracting values common to two lists, ... > I want to be able to use lookup to extract values common to two list. ...
    (microsoft.public.excel.newusers)
  • Re: Difference between two ranges
    ... you have another list in column B cell range from B1:B10 ... Another frequent tasks involving lists is to create a list containing values ... that you want to extract items. ... > Extracting Values Common To Two Lists ...
    (microsoft.public.excel.misc)