Eye tracking analysis of spacebar

[Akerblom]

Hi,

I have a problem where I have timedata in seconds with start time (startT), end time (endT) and the time where someone pressed spacebar. I would like to run the range of all spacebar presses to see if they match in between startT and endT. If and when they do I want them to be inserted in spacebarMatch in sheet 2. New values marked with (). Se example data below.

Sheet 1
spacebarPress
2
4
13
--------------------------------
Sheet 2
startT endT spacebarMatch
1 3 (2)
4 9 (4)
10 13 (13)
14 19 (18)
Etc...

Tried this but it did not work, perhaps it shows what I'm trying to do.

Please Login or Register  to view this content.

Does anyone have the solution for this?

Best,
Linus