Excel Custom Filter by Latest Date per unique ID

Heyas,

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.
SampleData.xlsx
Results.xlsx
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.
SampleData.xlsx
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Thank very much experimenting now.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad to help.
0
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.