Hey Guys -
I am working in an environment where a tool is reporting random statuses for various systems so I am trying to identify different details between each day. Over the past 3 days, I've collected about a dozen columns of data for ~30,000 systems for a site. Each is saved in it's own file. Below are a few rows with headers for example:
firstam1.jpg
What I'm trying to do now is create a report which shows the following:
- List rows which were not listed on any of the 3 daily reports (Comparing only columns A, B & C)
- Show which days the compared rows did / did not appear
- Highlight or separately list systems (column A) which appeared in multiple reports, but the B and/or C columns were different
- The final report should show the full row (all original columns) for systems listed - even though only comparing hostnames.
If only comparing 2 days, I could just add a new column showing the date the report was taken to each, combine them into a single spreadsheet, then remove duplicates. Since i have 3 days, I'm unsure of the best method, though.
Any suggestions? If it helps, I have Excel 2016 plus have KuTools installed. Hope I explained this well enough.
Thank You!
Bookmarks