[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 654
  • Last Modified:

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?
1 Solution
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?

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now