Powershell to compare two files


I have an excel file with two columns.

Column1 has a list of assets that we sent to a storage company.

Column2 lists the assets that they are returning to us.

I need to ensure that:

i. There is nothing from Column1 that is missing in Column2

ii. There is nothing extra in Column2 that is not in Column1

So, basically, I need to compare the two columns.

Is there a straightforward method to do this via Powershell?
Who is Participating?
Julian123Connect With a Mentor Commented:
You can do this with powershell. This link has details and examples: http://philergia.wordpress.com/2011/07/28/comparing-multiple-files-using-powershell/
David L. HansenProgrammer AnalystCommented:
If the two columns should contain the exact same data when all is said and done, why not just use conditional formatting to colorize the cells in column 1 which do not exist anywhere in column 2?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.