comparing trends of numbers in a column

ericel

New Member
Joined
Aug 17, 2010
Messages
2
Hi there,

I have a series of numbers, some positive and some negative.

-400
400
500
600
-300
-500
400
500
600
0
400
-600
700
-800
-300
500
600
0
300

A series of consecutive positive numbers is an uptrend, and a series of consecutive negative numbers is a down trend. A "0" continues the established trend. The trend is cumulative.

I need to compare the current trend to the previous trend.

If the current trend is greater than the previous trend the result is a "+", and if it is less, then it is a "-". The correct result would be...

-400
400
600 +
500 +
-500
-300
400
600 +
500 +
0 +
400 +
-600
700 +
-800 -
-300 -
500
600
0
300 +

The trend lengths will not be consistent, so I am having trouble comparing one trend against another to determine the "+" or "-" result I am after. Is there a way to compare trends of numbers?
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

iliace

Well-known Member
Joined
Jan 15, 2008
Messages
3,543
Office Version
  1. 365
  2. 2016
  3. 2010
Platform
  1. Windows
Not really clear, because your output is inconsistent. You have:

500 +
-500
-300

but no minus next to -300. You have:

700 +
-800 -
-300 -

with a minus next to -800 where, based on your question, there should not be one. Also, you treat your first zero as positive but not the second. And, the third from last 600 should have a +, again based on the question.

Please clarify.
 
Last edited:

ericel

New Member
Joined
Aug 17, 2010
Messages
2
Hi iliace, thanks for the reply. I will try to clarify.


500 +
-500
-300

The trends are cumulative. So -300 does not get a "-" because the negative down trend it is in currently only equals -800 (-500+(-300)=-800) and that is not greater than the previous up trend (400+600+500=1500).

700 +
-800 -
-300 -

In this part, the down trend of -800 is greater than the previous up trend of 700, and that is why it get's a "-".

The first zero is part of an up trend (400+500+600+0=1500), and that is greater than the previous down trend (-300+(-500)=-800). That is why it get's a "+" designation.

The second zero is also part of an up trend (500+600+0=1100), but it is not greater than the previous down trend (-800+(-300)=-1100). In this case the trends are only equal and so therefore no designation is assigned.

The third from the last 600 does not get a positive designation either for the same reason as the second zero.

I hope that helps clear up the results I am after.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,687
Messages
5,597,541
Members
414,154
Latest member
thevaper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top