Trending data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hello,

Is somebody able to help me work out how to create a formula which will
look at a set of data and provide a result indicating whether the
overall trend is upwards or downwards, and some other useful info such
as:

i.e data set:
JAN=40% FEB=43% MAR=42% APR=47% MAY=50%

i.e. Result:
OVERALL TREND over 5 months=UP
JAN-MAY Movement = +x%
This is x% away from target

Is this possible in excel?
Look forward to your feedback.


--
asim
------------------------------------------------------------------------
asim's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35530
View this thread: http://www.excelforum.com/showthread.php?threadid=559090

.

Relevant Pages

  • Re: Trend Perfect Butt
    ... >I have just been reading a tool catalogue and came across an advert for this ... >device which the makers, Trend, claims to be the worlds fastest profile ... >irregular feature and the pencil will accurately copy the profile directly ... fitting a cabinet scribe molding to a lumpy wall is a good ...
    (rec.woodworking)
  • Re: Trend and Seasonality
    ... indicating the beginning ... and let's see if there are any posters out there (besides me ... By the way you don't want to rempve anything ...not trend .. ... All to Gain .. ...
    (sci.stat.consult)
  • Profit Margin Trend
    ... I need to work out the projected future profit margin based on the ... What would be the trend for the rest of the month based on the above. ... uplink600's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9408 ...
    (microsoft.public.excel.programming)
  • Quantify trend line
    ... On a chart where the trend line completes the last couple of months ... Brisbane Rob ... Brisbane Rob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25096 ...
    (microsoft.public.excel.misc)