Compare 2 Excel-sheets
Posted on 2013-06-14
I'd need to compare the content of 2 Excels.
Both of them contain a list of servers.
Excel1: the servername column is "hostname" (no filter needed there).
Excel2: I filtered out Linux-servers (which I don't need) in Excel1, the column of servers there is named "Name"
How can I compare both sheets and have an overview of which servers are in sheet 1 but not in sheet 2?
In other words, f.e. is server1 in excel1 also there in excel2, is server22 in excel1 also there in excel2 etc.