Results 1 to 4 of 4

Find Date and Time for a value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-09-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    390

    Find Date and Time for a value

    Hi All,

    I have a set of data. Col A is a range of dates and row 1 is range of time. I need to look up in these data and find the Min value and the date and the time that Min value occured. Can anyone help please?

    I have attached the spreadsheet for example of what I am looking and better understanding. My Data is on Data sheet and my expectation is on Analysis sheet.

    Thanks.
    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. [SOLVED] find second to last date & time
    By SHAYJOSH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2016, 02:30 PM
  2. Replies: 1
    Last Post: 03-16-2016, 08:19 PM
  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. [SOLVED] 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