+ Reply to Thread
Results 1 to 4 of 4

find second to last date & time

Hybrid View

  1. #1
    Registered User
    Join Date
    09-17-2015
    Location
    tlv
    MS-Off Ver
    2007
    Posts
    16

    find second to last date & time

    Hi,

    I have a file with a log-in form.
    with every user entreing the file the log is saved.
    I want to show the users last Visit.

    the current users name is in O8
    the user name logs list is in B8:B500
    the date & time logs list is in C8:C500

    this array formula works great for getting the user latest entrence:

    {=MAX(IF(O8=B8:B500, C8:C500))}

    The thing is the latest date will always be the current one.
    I need to find the users SECOND TO LAST time & date.

    Any ideas??

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: find second to last date & time

    Try

    =LARGE(IF(O8=B8:B500, C8:C500),2)

  3. #3
    Registered User
    Join Date
    09-17-2015
    Location
    tlv
    MS-Off Ver
    2007
    Posts
    16

    Re: find second to last date & time

    Tnx JONMO!!
    you made it so simple :-)

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: find second to last date & time

    You're welcome

+ 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: 03-16-2016, 08:19 PM
  2. How to find the duration between date & time.
    By irfanpsr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2016, 06:42 AM
  3. Replies: 4
    Last Post: 12-12-2014, 08:03 AM
  4. find first & last date/time
    By y_not in forum Excel General
    Replies: 3
    Last Post: 07-12-2011, 06:43 AM
  5. Find the Difference between date and time
    By simi in forum Excel General
    Replies: 11
    Last Post: 09-18-2009, 11:05 AM
  6. "Time" problem: Need function to find time&date - ?hours
    By Powrpak in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2008, 08:15 PM
  7. find date & time
    By rob in forum Excel General
    Replies: 1
    Last Post: 09-19-2005, 06:05 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