Finding Like Combinations of Data Points

[Brabed]

If I have three consecutive cells that have a certain relationship with each other, how can I find a similar relationship within a data range?

Example-My last three cells are 1,3, and 5 and I decide I want to find another place within the data with three consecutive odd numbers.

This is a rough example, I may want to find three consecutive cells whose sum is <9, would be another example.

Thanks in advance....

 

[RalphA]

For your "...with three consecutive odd numbers", here is my solution, assuming your data is in A1:down, enter, in B1:
=IF(AND(A1/2<>INT(A1/2),A2-A1=2,A3-A2=2),A1&", "&A2&", "&A3,"")
and copy down.


For the "sum<9", I would use, say, in C1:
=IF(A1+A2+A3<9,A1&", "&A2&", "&A3,"")
and copy down.