Results 1 to 15 of 15

Find Last value on Multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    01-17-2024
    Location
    Australia
    MS-Off Ver
    MS365 Version 2406
    Posts
    7

    Find Last value on Multiple conditions

    I need to find the last log OUT time on a certain date for a certain person. This is dues to multiple sign-outs on same day at different times and i want to find the last time. My current formula always returns the first time which is great for the start time but not so good for the end time.

    Start times and Finish times are on separate sheets

    This is my Formula for the start time
    =IFERROR(INDEX(tbl_in[[#All],[Timestamp]],MATCH(1,(tbl_in[/B][[#All],[DATE]]='Times Check'!$AL$1)*(tbl_in[[#All],[1st Initial/Last Name]]='Times Check'!$A3),0)),"")

    This is my formula for finish time
    =IFERROR(INDEX(tble_out[[#All],[Timestamp]],MATCH(1,(tble_out[[#All],[DATE]]='Times Check'!$AL$1)*(tble_out[[#All],[1st Initial/Last Name]]='Times Check'!$A3),0)),"")

    Where
    AL = DATE
    A3 = persons name.


    So, i am matching the date and the person's name at present but as above it always returns the first value where i need it to return the last value on that day for that person.


    Snap of the OUT spread sheet.
    Screenshot_1.jpg


    Any help appreciated
    Attached Files Attached Files
    Last edited by Wazza450; 07-23-2024 at 12:50 AM. Reason: added file example

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to find multiple conditions
    By Serpan75 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-22-2020, 09:13 AM
  2. Multiple search conditions to find value
    By MARGI123 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-04-2019, 11:05 PM
  3. [SOLVED] Need to find average with multiple conditions
    By Bhavya2312 in forum Excel General
    Replies: 7
    Last Post: 09-07-2018, 04:18 AM
  4. [SOLVED] Find sum with multiple conditions of 'top n values of a table'.
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-14-2016, 09:12 AM
  5. Find a value using multiple conditions
    By tony7659 in forum Excel General
    Replies: 4
    Last Post: 09-01-2011, 03:19 PM
  6. Find and Replace with multiple conditions problem.
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-12-2010, 06:06 AM
  7. vlookup with conditions to find multiple entries
    By excelnerd1 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 02-05-2009, 05:56 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