Hi there -
I'm struggling with pulling some data for excel and I think that I need an formula, but I'm not sure. Any help would be VERY appreciated!
I've got a list of data that indicates the date and time that about 2,500 people completed up to 8 separate actions. The data is in the format: User ID #, Date completed (xx/xx/xxx xx:xx), and Action ID. I need to pull the date and time when they completed their last action. The issue I'm running into is that these actions don't have to be in a particular order, so they could have completed action #5 before action #8, thus action # 5 would have a later 'date completed' time stamp. And this is the timestamp I want.
I'm not able to do this in a pivot table since it converts the date to another format. Anyone have any ideas of a formula that I can use to complete this? Or if there is a way that I can sort this data via pivot or sort?
Any help would be VERY MUCH appreciated.
Bookmarks