computer name | updates | updated | last updated |
comp1 | 1-1-2021 | no | 3-1-2021 |
comp1 | 2-1-2021 | no | 3-1-2021 |
comp1 | 3-1-2021 | yes | 3-1-2021 |
comp1 | 4-1-2021 | no | 3-1-2021 |
comp1 | 5-1-2021 | no | 3-1-2021 |
comp2 | 1-1-2021 | yes | 2-1-2021 |
comp2 | 2-1-2021 | yes | 2-1-2021 |
comp2 | 3-1-2021 | no | 2-1-2021 |
comp2 | 4-1-2021 | no | 2-1-2021 |
comp3 | 1-1-2021 | yes | 4-1-2021 |
comp3 | 2-1-2021 | no | 4-1-2021 |
comp3 | 3-1-2021 | yes | 4-1-2021 |
comp3 | 4-1-2021 | yes | 4-1-2021 |
Given the first 3 columns I am trying to create the 4th column. I'm looking to find when the last update was taken for each computer.
exactly! The summarize tool.... I should have known. thank you so much!