ExcelBanter - how to compare columns in 4 worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to compare columns in 4 worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/47234-how-compare-columns-4-worksheets.html)

Ellen

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?

All times are GMT +1. The time now is 09:04 AM.