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.
Bookmarks