Hello,
I have a list of persons in one worksheet and another worksheet with testdates and results of these people. Now I want to be able to have a field behind each person on the worksheet with the list of perons with the LAST date they were tested. I Think I would have to use the functions LARGE and IF, but haven't been able to figure out how to make it work.
Any suggestion would be greatly appreciated...
I have attached the file I'm working with....
Bookmarks