Excel Custom Filter by Latest Date per unique ID


See attached excel file 'SampleData'

My query is how would I go about using the 'Filter Tool' to filter records on the latest date in Column 'C' for each individual ID Column 'A' automatically.

For an example of what I mean after I had applied the filter, see attachment 'Results'

I am running Excel 2010.

Any assistance is appreciated.

Thank you.
ZackGeneral IT Goto GuyAsked:
Who is Participating?
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
You may use the Pivot Table to get the desired output.
Refer to the attached for more details.
ZackGeneral IT Goto GuyAuthor Commented:
Thank very much experimenting now.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.