How do I collect the most recent row data under a parent?
I have a sheet that I collect our vehicle information on each month.
I manually move new rows to under the correct parent row.
The issue I'm having is I can't find a formula to collect the most recent data from the children rows.
I want the parent row in each circled column to behave the same way latest comment does and the information I am trying to collect isn't numbers or dates.
Any ideas on a formula that could work?
Help Article Resources
Check out the Formula Handbook template!