View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] sunnykumar948@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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