Results 1 to 1 of 1

Isolating data between two time points

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2011
    Location
    York, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Isolating data between two time points

    Hi all

    I'm pretty new to using Excel, and have only picked up a few basic things, but I'm trying to create a spreadsheet for a datalogging system that will automatically find the required data when the whole datalogging file is pasted in, and therefore create graphs based on that data.

    I've hit a snag here, as the data I'm interested in is cyclic. I'm only interested in the data in one particular cycle. I've found the beginning and end points of the cycle I'm interested in, but want to take out the corresponding cell data from the preceding columns.

    To be more specific, I'm looking at the time from column A, and want to find all the corresponding data in column B (load) and column M (velocity), when the time is between 10212 (cell J23) and 11439 (cell J26).

    I'm sure there's a simple solution to this, but Excel isn't helping a novice like myself. I've tried to paste the two equations used to calculate cells J23:

    =INDEX(A:A,MATCH(K13,M:M,0),1)
    and J26:

    =SMALL(A:A,COUNTIF(A:A,"<"&(1/(K13/(PI()*K2))*1000)+(INDEX(A:A,MATCH(K13,M:M,0),1)))+1)
    into the following equation:

    =VLOOKUP(SMALL(A418:A468,1),A:D,2)
    (where the formula states 'A418:A468' is where I pasted the equations for cells J23 and J26), but Excel always gives me an error, but wont explain the part of the equation that is wrong. Basically, Excel doesn't like this code:

    =VLOOKUP(SMALL(INDEX(A:A,MATCH(K13,M:M,0),1):SMALL(A:A,COUNTIF(A:A,"<"&(1/(K13/(PI()*K2))*1000)+(INDEX(A:A,MATCH(K13,M:M,0),1)))+1),1),A:D,2)
    When I type the cell references in directly into the formula it works, but I'm trying to automate the whole operation.

    I've attached the workbook in case anyone would like to take a look. Sorry if this was very long winded, but like I said I'm very much a novice at this and wanted to explain myself as fully as possible.

    I'd be very appreciative of any help that can be offered. Thanks.
    Attached Files Attached Files

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