values reached which boundary first ?

[Mgd_Elislam]

Hi all
first i want to thank all administrators, moderators, contributors and also members for the value they provide and their clear effort in helping others

I am using MS Excle 2010
i was think that i am professional in excle but when i came here i found that i am so far

i have a huge raw data that i want to manipulate it to reach to a specific conclusion

it's an array of numbers, and i measure the change between every new value and the previous one "

column ​

D",
and if the change was greater than or equal pre-assign value "E1",
i start to focus on it and observe whether after this change will reach to a greater value in the flowing numbers or to the lower value first ?

i want to add two boundary, Above and Blew, for example +10 and -10 , and want to know what will be be reached first after the change ?

I have no problem to add more columns to calculate this ( and i prefer this)
to use this kind of formula with array (Ctrl+Shift+Enter) not a suitable solution as i have to fill it over thousand or rows

finally, i will filter them to count which of them reached to the upper limit first, and which reached to lower level first

i hope that i clear the issue and thank you for any suggestion

in this sample i attached, i have two numbers (in row 9 and 22) have the specific change "10", and after i follow them i found that they reached to the upper limit first

 

[mikerickson]

I'm not sure what you are looking for. Could you post a small sample of data and your desired result?

 

[Mgd_Elislam]

I'm not sure what you are looking for. Could you post a small sample of data and your desired result?

Thanks you for help

ok, at simple way

i have a series of values and all what i want is to calculate the difference between every two values and if it is grater than 10 , i look at it's following value it the values go up further +10 the result be "Up", if the following values go down -10 the result be "Down"

A	B	C
Numbera	difference	result
135842
135841	-1	Down
135839	-2
135851	12
135843	-8
135843	0
135838	-5
135833	-5

<tbody>
</tbody>

my problem is in the c column, how can i get it depend on the following ?

 

[mikerickson]

-1 to -2 is not a decrease by 10, why is there Down there?

 

[Mgd_Elislam]

sorry it was writing fault, this is what i mean

	A	B	C
1	Numbers	difference	result
2	135842
3	135841	-1
4	135839	-2
5	135851	12	Down	As the "A8" reached to -13
6	135843	-8
7	135843	0
8	135838	-5		here the following values reach -13 135838-135851=-13
9	135833	-5

<tbody>
</tbody>

thank you

 

[Mgd_Elislam]

any one can advice or help

 

[Mgd_Elislam]

No problem to have the solution over VBA code