| 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.
