Excel 2007 : reg - check the trend

**raminsap** · 01-23-2010, 07:29 AM

hi all,
iam very new to excel. i want to chack all the tabs in a row.

item code apr may jun july aug sep oct
100 50 60 62 73 75 76 77

like wise iam having 2000 rows. i want to know whether it is increasing trend or decreasing trend. and also for some of the months tabs may empty

pls help me

RAM

**zbor** · 01-23-2010, 07:31 AM

You can do =SIGN(TREND(A1:H1))

If it's 1 it's positive, -1 negative, 0 no trend

**teylyn** · 01-23-2010, 07:34 AM

how do you define a trend if the numbers are not continuous?

In your example, each cell is greater than the cell in the previous colum. What logic would you want to apply if the scenario is not that linear? Compare first with last? Compare average with last? Compare average with first?

Please provide a few more data samples and manually mock up the solution you would like to see. Explain the logic that leads to it. If there's logic, there will be a solution. But you will have to provide the rules.