Results 1 to 5 of 5

Display a number in another worksheet by matching up ID then within certain time range

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    SD
    MS-Off Ver
    Excel 2003
    Posts
    8

    Smile Display a number in another worksheet by matching up ID then within certain time range

    I am hoping to display a pain score from one worksheet to another worksheet. The common link between the two worksheet is a subject ID number.
    The problem that I run into is that these scores are recorded at different times.
    I am hoping to have a formula where I can match up the score that is at least within +/- 5 mins when these scores are recorded.

    I've posted an example below, please let me know if this makes any sense.
    Any help or comment would be greatly appreciated.
    Attached Files Attached Files
    Last edited by wuoshi1031; 01-14-2014 at 02:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display corresponding value of matching number
    By Pieterdeboer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2013, 10:34 AM
  2. Display the date and time each time the data in a cell range is changed
    By BVZM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2012, 01:23 PM
  3. Display A Number on Matching Set of Combo Number
    By ctxme7 in forum Excel General
    Replies: 17
    Last Post: 03-26-2012, 03:31 PM
  4. Display info from a separate report by matching the date
    By Srp in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-02-2011, 11:43 AM
  5. Replies: 3
    Last Post: 06-27-2007, 03:16 AM

Tags for this Thread

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