Repeated Measures (CountIF and VLookup)

Hi all,   The data I'm dealing with in Excel has IDs with multiple entries (visit counts), as seen below. Each entry for an ID has been sorted by date (oldest first – not shown) and has been assign...