I am having trouble created a certain formula I need. Here is my
attempt at an explanation:

I have one very large column of values, where each value is either a
2,3, or 5. I want to extract in another column all of the 2s that are
preceded by a 3 before they are preceded by a 5, as well as the cell
with the 3 in it That is, if there is 2 value in cell BB193, and BB
190:BB192 are all 2s also, but BB189 is a 3, then I want all of those
values in a new column. However, if BB191 is a 5 instead of a 2, then
I do not want values BB193:BB191 (BB190 and BB189 will depend on
whether a 3 or a 5 precedes them first). I should note that there are
many 2s 3s and 5s interspersed throughout my datasheet in a seemingly
random fashion.

Any ideas? Please let me know if I need to clarify.

Thanks,
Hos

I think you will need VBA to do this. Are you saying you want all 2s which
are delimited by 3 and 5 copied (along with the 3).

Are all the patterns below valid?

2
2
3 < copy
2 <copy
2 <copy
3 <copy
2 <copy
2 <copy
5
2
2
3 <copy
2<copy
3<copy
2<copy
2<copy
5
2

"Hosley" wrote:

I am having trouble created a certain formula I need. Here is my
attempt at an explanation:

I have one very large column of values, where each value is either a
2,3, or 5. I want to extract in another column all of the 2s that are
preceded by a 3 before they are preceded by a 5, as well as the cell
with the 3 in it That is, if there is 2 value in cell BB193, and BB
190:BB192 are all 2s also, but BB189 is a 3, then I want all of those
values in a new column. However, if BB191 is a 5 instead of a 2, then
I do not want values BB193:BB191 (BB190 and BB189 will depend on
whether a 3 or a 5 precedes them first). I should note that there are
many 2s 3s and 5s interspersed throughout my datasheet in a seemingly
random fashion.

Any ideas? Please let me know if I need to clarify.

Thanks,
Hos

On Apr 28, 4:12 am, Toppers wrote:
I think you will need VBA to do this. Are you saying you want all 2s which
are delimited by 3 and 5 copied (along with the 3).

Are all the patterns below valid?

2
2
3 < copy
2 <copy
2 <copy
3 <copy
2 <copy
2 <copy
5
2
2
3 <copy
2<copy
3<copy
2<copy
2<copy
5
2

"Hosley" wrote:
I am having trouble created a certain formula I need. Here is my
attempt at an explanation:

I have one very large column of values, where each value is either a
2,3, or 5. I want to extract in another column all of the 2s that are
preceded by a 3 before they are preceded by a 5, as well as the cell
with the 3 in it That is, if there is 2 value in cell BB193, and BB
190:BB192 are all 2s also, but BB189 is a 3, then I want all of those
values in a new column. However, if BB191 is a 5 instead of a 2, then
I do not want values BB193:BB191 (BB190 and BB189 will depend on
whether a 3 or a 5 precedes them first). I should note that there are
many 2s 3s and 5s interspersed throughout my datasheet in a seemingly
random fashion.

Any ideas? Please let me know if I need to clarify.

Thanks,
Hos

Yes, that's right. I actually found another software program to do
what I need, but I appreciate your help. I think really need to learn
Visual Basic if I'm going to get any better with Excel.

Thanks again,
Hos