View Single Post
  #1   Report Post  
Ellen
 
Posts: n/a
Default how to compare columns in 4 worksheets

I have someone who has 4 Excel spreadsheets with info in different columns.
Is there a way to have Excel compare all columns he chooses and hilight or
somehow indicate the fields that are the same in multiple
columns/workstheets?