<div>
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?
</div>


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?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have an excel file with two columns.<br />
<br />
Column1 has a list of assets that we sent to a storage company.<br />
<br />
Column2 lists the assets that they are returning to us.<br />
<br />
I need to ensure that:<br />
<br />
i. There is nothing from Column1 that is missing in Column2<br />
<br />
ii. There is nothing extra in Column2 that is not in Column1<br />
<br />
So, basically, I need to compare the two columns.<br />
<br />
Is there a straightforward method to do this via Powershell?
</div>
</div>


Hi

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?

Powershell to compare two files

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.