Afternoon Excel whizzes!
I have a sheet that tracks inventory by customer every day over several months. I am trying to figure out the most recent date that an account has "closed" (defined as going to 0) its inventory.
Untitled.png
I know I need to index the dates, but can't figure out exactly how to setup the criteria such that the formula returns the most recent date an account has closed. Please let me know if you need further clarification! Thank you!
Bookmarks