+ Reply to Thread
Results 1 to 2 of 2

Trying to consolidate items and list only the items with the latest date

  1. #1
    Registered User
    Join Date
    04-01-2015
    Location
    Maine
    MS-Off Ver
    2013
    Posts
    1

    Trying to consolidate items and list only the items with the latest date

    See example below. I want each tag listed once with the latest date and sorted by the date.

    This is how it looks now:

    Date Tags
    2/20/2015 Alumni Hall
    2/18/2015 Alumni Hall
    2/2/2015 Alumni Hall
    1/22/2015 Alumni Hall
    2/5/2015 Alumni Place
    1/26/2015 Alumni Place , Deering Hall
    2/13/2015 Androscoggin Hall
    2/10/2015 Aubert Hall
    2/9/2015 Aubert Hall
    3/4/2015 Barrows Hall
    2/23/2015 Barrows Hall
    1/23/2015 Boardman Hall
    1/23/2015 Boardman Hall
    1/22/2015 Boardman Hall
    1/22/2015 Boardman Hall
    2/20/2015 Chadbourne Hall
    2/19/2015 Chadbourne Hall
    2/16/2015 Chadbourne Hall
    2/13/2015 Chadbourne Hall

    This is how I want it to look:
    1/23/2015 Boardman Hall
    2/5/2015 Alumni Place
    2/10/2015 Aubert Hall
    2/13/2015 Androscoggin Hall
    2/18/2015 Alumni Hall
    2/20/2015 Chadbourne Hall
    2/20/2015 Alumni Hall
    3/4/2015 Barrows Hall

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Trying to consolidate items and list only the items with the latest date

    Hi,

    I used a simple pivot table. (see attached)

    For the dates, use MAX for the values.

    Hope this helps.

    Simple pivot for dates.xls

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  2. Consolidate Unique List Items into an Adjacent Column
    By packetdog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-09-2012, 11:29 AM
  3. Select and Display latest date items only
    By HMIExcel08 in forum Excel General
    Replies: 4
    Last Post: 12-02-2008, 03:20 PM
  4. Replies: 1
    Last Post: 06-24-2005, 12:21 AM
  5. [SOLVED] Items in disabled items list - unknown excel addins causing probs
    By Rich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1