View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr. Darrell Dr. Darrell is offline
external usenet poster
 
Posts: 74
Default I want to compare the values in two columns

I have a list of 1,000 Document Titles in Column A and I have a list of 1,200
Document Titles in Column B.

I would like to compare the tiltes in Column A to those in Column B. Ideally
all 1,000 titles from Column A should be in Column B as well.

Is there a function in Excel to allow me to identify all the titles in
Column B that are equal to the Titles in Column A?