In the attached spreadsheet, I'm trying to determine how long each individual animal stays at an animal shelter. The "Outcomes" worksheet contains the Animal ID# (Column A), which identifies each animal, the outcome date (Column C) and intake date (Column D) which I'm trying to match to intake dates in the "Intakes" worksheet (Column C). The standard index and match form works fine if an animal comes in only once. However, if an animal comes in more than once, the index and match functions pulls the same date since the animal has the same Animal ID# (Column F).
I'd like to sort both the outcomes and intakes in descending date order and then match the latest intake dates with the latest Animal ID # outcomes to properly calculate how long each animal stayed at the facility.
Any help would be most appreciated.
Bookmarks