I have a large data table that was not very well put together. I need to find the last test date a student took a specific test in a range that contains also contains dates for the other tests they've taken. My table is as such:
ID | LName | Test Date | Math Test | Score | Eng Test | Score |...