View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Compare the data in 2 columns

Hi
I would like to the compare the in Column A and Column C. Display in Column
D an the common data of A and C and Column E the associated value of Column A
in Column B For example

A B C
12 P1 23
23 p2 24
25 P3 12

Clomun D and E must have the following values
D E
12 P1
23 P2
Can anyone help me