+ Reply to Thread
Results 1 to 2 of 2

How to: Compare multiple dates and enumerate cell in row with most recent date

  1. #1
    Tred
    Guest

    How to: Compare multiple dates and enumerate cell in row with most recent date

    Howdy All,

    This is what I want to do:

    I have a spreadsheet with 4 dates in columns I, J, K, and L starting in row
    3.

    In the corresponding columns of row 1, i want to count the number of times
    each column contains the most recent date.

    Example:

    I3 = 1/1/2000, J3 = 2/2/2001, K3 = 3/3/2002, L3 = 4/4/2003

    L3 would now equal 1.

    Then next time column L contains the most recent date, L3 would enumerate
    and equal 2, etc.

    Any ideas?

    Thanks,
    Brian




  2. #2
    Pete_UK
    Guest

    Re: How to: Compare multiple dates and enumerate cell in row with most recent date

    You have replies at your other post - please do not multi-post.

    Pete


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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