Extracting data next to a cells that match a given range.

[montana7244]

Hello,

In my Excel sheet, I have a leftmost column of rounded times (in seconds). These go like 0,0.01,0.02,0.03,0.04,0.04, etc (sometimes there is repetition of a number, but that doesn't matter very much). In the two columns beside it, Columns B and C, I have data that I want to extract. However, I have several ranges of times for which I want to extract data (ex. 0.04-1.04 seconds, 1.11-2.11 seconds). In my actual data set, the time in between will always be 10 seconds.
So I want my chosen ranges to match the numbers in Column A, and then find the data next to the range in B and C.

How can I do this?

I have attached a spreadsheet showing what I mean, where I manually extracted some data that matched a range (start time and end time). I want to find a way to automate it

Any help would be greatly appreciated!
Please ask if you are confused by what I mean.

Sincerely,
Montana

[Phuocam]

Hi,

Try this in cell I2:

=IFERROR(INDEX(B$2:B$38,AGGREGATE(15,6,ROW($A$2:$A$38)/($A$2:$A$38>=$F$2)/($A$2:$A$38<=$G$2)-ROW($B$1),ROWS(I$2:I2))),"")

[Limor_OP]

Hi,
If you have office 365 you can use the filter function:

In I2 (the formula spills to other columns and lines):
=FILTER(B2:C38,(A2:A38>=F2)*(A2:A38<=G2))

In M2:
=FILTER(B2:C38,((A2:A38>=F3)*(A2:A38<=G3)))

[montana7244]

Thank you belinda200! This solution is so simple, and it worked perfectly

[Limor_OP]

You're welcome. The new functions of Filter/Unique/Sort that excel has in 365 version are really helpful and saves a lot of time.