Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trending data
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...o&userid=35530 View this thread: http://www.excelforum.com/showthread...hreadid=559090 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |