PDA

View Full Version : Solved: Recent session date



acraens
10-29-2011, 01:08 PM
As you could see in the attached file, i'm having problems finding the most recent session date for a specif person (use of ID nr)

If anybody could help me in the right direction? I'm using excel 2007 on a windows 7 OS

Thanks
Alex

mancubus
10-29-2011, 03:44 PM
try...

you're looking for the max date in column a in sheet "data".
Blad1!C3 formula:
=MAX((DATA!$B$2:$B$14=C1)*(DATA!$A$2:$A$14))

acraens
10-30-2011, 05:35 AM
thanks a lot, that did the trick

gr
Alex

mancubus
10-30-2011, 10:18 AM
you're wellcome...