Need Help With A Formula

How can get the MAX(Inspection Date) by Vehicle and return only those rows in a sheet? (Placing those rows in a new sheet)

Example: Rows 2 & 3 should be returned in this case.

Row     Vehicle Nbr        inspection Date                Column A            Colum B

1             20                          12/19/22

2             30                          08/17/22

3             20                          01/10/23

4             20                          11/30/22

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!