compare fields to make new column

[drake158]

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.

[Jbone]

Hi Drake,

Is this what you are looking for?

[drake158]

exactly! The summarize tool.... I should have known. thank you so much!