On the attached sheet, I am looking to return the newest date entry for a employee.
The sheet shows what I am attempting to do, basically employees will have a series of dates next to their name.
Thanks for any help,
Nick
On the attached sheet, I am looking to return the newest date entry for a employee.
The sheet shows what I am attempting to do, basically employees will have a series of dates next to their name.
Thanks for any help,
Nick
Last edited by avidcat; 09-14-2012 at 05:57 PM.
In List sheet D2, enter with Ctrl + Shift + Enter key enter together
=MAX(IF(Data!$A$2:$A$31=List!A2,Data!$B$2:$B$31))
Awesome! Works just as I needed it.
I marked it solved, but I had another request, if no date has been entered as of yet for that employee, how can it show a "blank" instead of a date of January 00, 1900?
Maybe like this. =IF(MAX(IF(Data!$A$2:$A$31=List!A2,Data!$B$2:$B$31))="", "", MAX(IF(Data!$A$2:$A$31=List!A2,Data!$B$2:$B$31)) )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks