Display cells(text) in one column based on cells which are present inother column
 

hi all
i have a requirement that in my excel i have 2 columns A and B.
column A has some 5 values say they are some names of people.
column B has some 2 values .
Now i want find out the list of column A names which are also present
in column B in a seperate column
any help regarding this would be greatly appreciated

Display cells(text) in one column based on cells which arepresent in other column
 

Something like this?:

=IF(ISNA(MATCH(A1:B:B,0)),"No","Yes")

Copy this down as required - this will identify (by means of Yes) if
the name in column A can be found anywhere in column B.

Hope this helps.

Pete

On May 12, 11:58*am, wrote:
hi all
*i have a requirement that in my excel i have 2 columns A and B.
column A has some 5 values say they are some names of people.
column B has some 2 values .
Now i want find out the list of column A names which are also present
in column B in a seperate column
any help regarding this would be greatly appreciated