Excel 2013 can locate duplicate rows as long as one column contains ... matching rows based on common terms, such as first or last names. When the second set of data is located on a separate ...

Managing large Excel spreadsheets ... the selected column along with all columns to its left. The freeze panes feature is particularly useful for comparing data across distant rows or columns.