SharePoint Lists:  Filtering a list by finding maximum date across rows.

Posted on 2012-09-19
Last Modified: 2014-03-03
Hi Experts:

I have a list in SharePoint with multiple rows of data like this:

Name    Status      Date

I'd like filter my list so that I see only the _latest_ entry for each Name.

How do i do that?
Question by:epuglise

    Accepted Solution

    If you use SharePoint Designer, you could create a Data View Web Part that sorts the list by the columns Name, Modified and then uses XSLT filtering to hide any row but the first for each name.

    Have the DVWP include the Name, Status en Date columns and show all items.

    This should perform okay if your list isn't too long (say, a maximum of 1000 items). If your list is longer, you could try any of the following:

    1. Create a second list with similar columns and create a workflow or event receiver that runs whenever a new item is added to the first list. Here, you add or update an item in the first list, for each user.

    2. Create a custom web part that uses a query to select only the top result for each name.

    Author Comment

    I do not have SharePoint Designer.  I am thinking of connecting the SP list to an Access table and then having a query create a second list, which I'd then link to SP as well.  I would still have to refresh the data manually, but it isn't that dynamic.

    In the meantime I will also see if I can get Designer installed.

    Author Closing Comment

    Didn't solve my issue, but might help someone else who has SP Designer.

    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

    If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
    There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video discusses moving either the default database or any database to a new volume.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now