Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Custom Filter by Latest Date per unique ID

Posted on 2016-09-01
3
Medium Priority
?
68 Views
Last Modified: 2016-09-04
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
0
Comment
Question by:Zack
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 2000 total points
ID: 41781040
You may use the Pivot Table to get the desired output.
Refer to the attached for more details.
SampleData.xlsx
0
 

Author Closing Comment

by:Zack
ID: 41784194
Thank very much experimenting now.
0
 
LVL 33

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41784211
You're welcome. Glad to help.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question