Mgd_Elislam
New Member
- Joined
- Jan 18, 2014
- Messages
- 5
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 "
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
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
Last edited:
