How to pull only most recent value?
Hi! I am trying to build a time allocation table for resources to track their time on projects by %age of time spent that week. Currently I use a weekly update request, with one row per TM that gets updated weekly. I would like to change to a form, where a new row is created each time the TM logs time, with the time/date stamp, so that we could eventually track time devoted to project over time. However I have a lot of reports that should only show the most recent time allocation entry. So in english what I would want is:
"Do a VLOOKUP on the employeeID, then return the value from column 3 where the volume in column 4 is the highest"
I can think of how to do it in SQL, and could figure it out in a traditional spreadsheet app, but not sure how to do it here?