Solved

Excel Custom Filter by Latest Date per unique ID

Posted on 2016-09-01
3
46 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 28

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 28

Expert Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now