Hi everyone, I'm battling with this one...would like an Index Match formula to find the last test result before a certain date for a certain userid e.g. at Oct 31 mchansa04 result of her last test was 60% written on 18th Sept. For techima05 its 68%. Thanks in advance!
Excel...