Help! with specifics in a data series

Hello,

I need to be able to copy data from one cell based on criteria from a parallel column, but... the criteria is a range and I need the copied data to occur when a certain condition is met. Is this possible?

Here is an example of the data:
A B
5 d
5 c
5 d
3 c
3 a
2 a
1 d
1 s
0 d
0 c
0 d

I would like for "s" to be copied to another cell but based on the criteria that a "1" had just occurred. I will have a data series and need to record data from column B based on when the first 1 occurred.

I hope I am being clear. Any assistance would be greatly appreciated. Thanks in advance.

I would only need the "s" to be copied. Just one value.

It looks like you were very close but I am still not getting the result I want.

My data series is actually going to use random numbers instead of letters. So I used the formula you had provided to my data series.
For some reason the value in column B that picks up is based on the highest value of Column B. For example:

A B
5 870
5 500
3 300
3 500
2 100
1 400
1 200
1 300
0 700
0 500

Your formula will return the result of 400 but I actually want it to return 300 because that is what had occurred when the number 1
started in the data set.

Thank you so much for all of your help! Do you think it would be possible to alter the formula you provided earlier to come up with
the desired results?

I took another look at the data. It looks like your formula is actually returning the third value down in column B when the number 1 starts occurring in column A. I will be using this formula on different data sets with the same layout of what I mentioned earlier but the value in A and B will differ slightly so the formula isn't working. The value that will be returned from column B may not necessarily be the third value down in column B. It may be the first or second, this will vary. I hope this is understandable. Please let me know if it isn't.

Thank you again.

Okie dokie, I've attached a data set similar to what I will be working with. With the example data I would need Excel to determine what the time (Column A) is when the number 5 starts occurring in Column B. I will be using this formula for different sets of data as well so the data in the table will change slightly and there may be more or less occurrences of 5 or the other variables.

Please let me know if this isn't clear. Thank you again!

Thank you soooo very much! You're amazing! I appreciate the help!