Solved

Excel Custom Filter by Latest Date per unique ID

Posted on 2016-09-01
3
55 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 30

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 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 30

Expert Comment

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

830 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