Hello Everyone,
I'm an electrophysiologist not an IT guru so you'll have to forgive the task I'm about to beg your help for:
So I shock my brain cell once then I'll shock it again after a 0.1ms delay. Then I'll do that again, but the delay will increase by another 0.1ms delay.
Here's my problem: I'm collecting data every 0.02ms, which is faster than the delays. The result is that the excel sheets come out to be oblong matrices.
For instance, If I have the following array of data, I'm only interested in the cells I've highlighted in red text.
0 -140 -140 -140
0 -140 -140 -140
0 -140 -140 -140
0 -140 -140 -140
0 -140 -140 -140
0 0 -140 -140
0 0 -140 -140
0 0 -140 -140
0 0 -140 -140
0 0 -140 -140
0 0 -140 -140
0 0 0 -140
0 0 0 -140
0 0 0 -140
0 0 0 -140
0 0 0 -140
0 0 0 0
Up until now, I've tried =index(A1:D1,,rows($1:1) which extracts the value of the square matrix about the diagonal of (A+1)(1+1). What I'm looking for is a formula to extract (A+1)(1+5). I would do this by hand if I had a few lines of data but I'm working with an array of 260K Cells right now so I'm desperate!
I appreciate your help!
-Bobby
Bookmarks