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?