+ Reply to Thread
Results 1 to 6 of 6

Finding the first appearance of the latest item

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,962

    Re: Finding the first appearance of the latest item

    This proposal employs two helper columns (F:G) which may be moved and or hidden for aesthetic purposes.
    Column F is populated using: =IF(OR(A2=A1,A2=""),"",AGGREGATE(15,6,C$2:C$50/(A$2:A$50=A2)/(B$2:B$50=B2),1))
    Column G is populated using: =IF(F2="","",AGGREGATE(15,6,ROW(A$2:A$50)/(A$2:A$50=A2)/(B$2:B$50=B2)/(C$2:C$50=F2),1))
    The conditional formatting rule is: =COUNTIFS($G$2:$G$50,ROW())>0
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Need to get the latest date in a column for each item number
    By gosforth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2014, 09:42 AM
  2. Need help showing the latest value on balance column for a particular item.
    By kittle08 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-31-2014, 10:17 AM
  3. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  4. Finding latest date
    By tbaskar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2013, 02:36 AM
  5. Finding Latest Available Data
    By the.ronin in forum Excel General
    Replies: 3
    Last Post: 10-25-2011, 12:43 PM
  6. finding latest price
    By wahib in forum Excel General
    Replies: 2
    Last Post: 07-12-2010, 11:20 AM
  7. Finding latest date
    By SilverHeli2000 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-22-2009, 02:13 PM

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