Very easy question about filter!!!

Tech-Archive recommends: Fix windows errors by optimizing your registry


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: Multiple After Update Event Procedures
    ... upon a query that has Department, Department Supervisor, Description, ... and then also has profile number, ... after update event that will fill in the Department Supervisor after ... referencing the third column of the ListBox. ...
    (microsoft.public.access.formscoding)
  • Re: Multiple After Update Event Procedures
    ... that load profile worked first. ... profile and list ID and they are in the appropriate columns. ... referencing the third column of the ListBox. ... in most cases copying data like this is the incorrect way to build a ...
    (microsoft.public.access.formscoding)
  • HELP!!! Trouble with IF, AND functions
    ... I am trying to create a function in a spreadsheet to run a test on two ... columns which computes the result for the third column, ... this but then my answer always winds up being 0. ... Ally1977's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31483 ...
    (microsoft.public.excel.worksheet.functions)
  • find largest values, then return corresponding row values.
    ... column "subtable" to condense data that will find the largest values in ... I can't do a lookup table because I am dealing with the third column, ... doesn't seem to be appropriate or I am not making the right tweaks. ... neurotypical's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34719 ...
    (microsoft.public.excel.misc)
  • Re: What functions should I use?...please assist.
    ... I have a problem with Excel. ... After this I would simply sum the 1s in this third column to ... edk256's Profile: ...
    (microsoft.public.excel)