I have one CSV file with a complete list of device names, a list of workstations and kiosks, then another file with a list of those device names that have been updated this month, sorted into 2 columns (WorkstationName and KioskName) by device type. I need to compare those 2 files just looking at the name and spit out the ones not in the first list to get the devices that weren’t updated this month.
[Here’s what I have currently, it just spits out a blank Excel sheet] (https://i.sstatic.net/rQsJy9kZ.png)
Ideally, I want the export file to have 2 columns (Workstations and Kiosks) showing which devices weren’t updated.
Any help would be greatly appreciated.
Thomas Brita is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.