Results 1 to 13 of 13

Countif formula using id strings (column1) and dates (column2): what's the best approach

Threaded View

jam320 Countif formula using id... 07-03-2014, 11:42 AM
etaf Re: Countif formula using id... 07-03-2014, 12:55 PM
jam320 Re: Countif formula using id... 07-03-2014, 03:50 PM
jam320 Re: Countif formula using id... 07-03-2014, 04:20 PM
jam320 Re: Countif formula using id... 07-03-2014, 01:46 PM
etaf Re: Countif formula using id... 07-03-2014, 04:20 PM
etaf Re: Countif formula using id... 07-03-2014, 04:23 PM
jam320 Re: Countif formula using id... 07-03-2014, 04:40 PM
etaf Re: Countif formula using id... 07-03-2014, 04:50 PM
jam320 Re: Countif formula using id... 07-07-2014, 09:01 AM
etaf Re: Countif formula using id... 07-07-2014, 05:33 PM
jam320 Re: Countif formula using id... 07-09-2014, 09:03 PM
etaf Re: Countif formula using id... 07-10-2014, 01:36 AM
  1. #1
    Registered User
    Join Date
    10-14-2013
    Location
    Ohio, US
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    46

    Countif formula using id strings (column1) and dates (column2): what's the best approach

    Here's what I need to figure out:
    Column1 has a list of 6-digit id strings sorted ascending with a varying amount of duplicates for each id string
    Column2 has accompanying dates entries of the ids

    I need to figure out a formula that counts ids with the most recent date, so that I can filter my list down to having 1 distinct entry per id based on the most recent date.

    I've attached an example. Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 07-01-2014, 10:56 AM
  2. [SOLVED] Counting cells based on date in column1 and an alpha-numeric value in column2
    By JStreck in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-24-2013, 12:47 PM
  3. Delete row containing column1 column2 etc
    By lemonstar in forum Excel General
    Replies: 2
    Last Post: 09-26-2011, 11:26 AM
  4. Replies: 4
    Last Post: 08-03-2011, 08:22 PM
  5. compare column1 with column2
    By myguess21 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-12-2005, 03:55 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