Need Help With A Formula

Mike B

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

Paul Newcome

You would have to manually input all of the vehicle numbers into the second sheet and then use a MAX/COLLECT to pull in the date.

Paul Newcome

You would have to manually input all of the vehicle numbers into the second sheet and then use a MAX/COLLECT to pull in the date.

Mike B

Thanks!!!

Paul Newcome

Happy to help. 👍️