This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Given below is my input data. I need to have one date for a given event. I want to filter this using "Last updated' column. It should look for the "latest time" and filter out the records because the last updated date is same.
My output should be (display line 2 Event and Event date)
I would sort by Last Updated descending so the latest file is towards the top, then Sample the information grouping the column by Event. This way if you have more events, you would get the latest updated per event.