Hey Guys -
I'm having issues trying to get some data I need, so wanted to post. Over the past 3 days, I've collected 15 columns of data for ~30,000 systems (one per row) into a single ~90,000 row spreadsheet. below is a Snippet:
Note, column D represents the date I captured the data and only has 1 of 3 values for the date.
What I'm trying to do is create one or more reports which will provide the below information:
- A list of systems (Column A) which are not listed on all 3 daily captures (Where 3 rows weren't present in the spreadsheet with the dates 11/5, 11/6, & 11/7)
- If the "Client Installed" state (Column B) differs between days regardless of how many days it was listed / not listed on
- If the "Last Install Error Code" (Column C) differs between days regardless of how many days it was listed / not listed on
The resulting report(s) should list all common columns for the system and if B/C differed, all rows should be shown for comparison. To note, I am using Excel 2016 plus have KuTools installed.
Thank You!
I'm having issues trying to get some data I need, so wanted to post. Over the past 3 days, I've collected 15 columns of data for ~30,000 systems (one per row) into a single ~90,000 row spreadsheet. below is a Snippet:
Note, column D represents the date I captured the data and only has 1 of 3 values for the date.
What I'm trying to do is create one or more reports which will provide the below information:
- A list of systems (Column A) which are not listed on all 3 daily captures (Where 3 rows weren't present in the spreadsheet with the dates 11/5, 11/6, & 11/7)
- If the "Client Installed" state (Column B) differs between days regardless of how many days it was listed / not listed on
- If the "Last Install Error Code" (Column C) differs between days regardless of how many days it was listed / not listed on
The resulting report(s) should list all common columns for the system and if B/C differed, all rows should be shown for comparison. To note, I am using Excel 2016 plus have KuTools installed.
Thank You!