Hello,
I need some help forming a function to find the latest report by each employee from a list of reports. I know I'll need to use MAX to find the date, but many employees have reported more than once but I only want to list one report per employee: their latest one. How could I go about doing this?
Attached is an example file. Thank you in advance, this has been bothering me for a while now.
Capture.PNG
Bookmarks