Find Latest Date for With a criteria in rows
I have a form that my field team inputs the action they make in customer, the same form is used for every customer, In Another sheet, I have the visit controle, and in this other sheet, I want to know the last visit my team made to each customer.
So I need to use a MAX formula for each specific customer.
The only solution I found was to user forms to enter the response in the upper rows, so my Vlookup brigs the latest entered visit, but it is not failure proof, so I would like the formula to look for the latest instead.
Help Article Resources
Check out the Formula Handbook template!