Originally Posted by

Hi Guys -

I have a simple dataset that counts illness occurance in a wee.
Something like this:

A B C D E
1 1/10/12 2/10/12 3/10/12 4/10/12 5/10/12
2 Mon Tues Wed Thurs Fri
3 ill ill

I am trying to find a function that will return the date of the last
occurance of illness in this instance 3/10/12.

Any help would be massively appreciated

Many thanks