From 2 predefined test data ranges, how do I detect which one has a anon linear trend through Excel VBA ?

u473

Guest

Posts: n/a

4th Dec 2010

For testing purpose, before I apply it to real data, I have a range of
non-contiguous dates in Col "A",
a linear range of data in Col "B", and a non linear range in Col "C".
How do I detect which range is linear ?
Help appreciated,

J.P.

« Recognize currency in a cell | Sum Dynamic Range »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
linear trend lines do not appear gaps in data	wirepusher	Microsoft Excel Charting	1	23rd Apr 2009 09:11 AM
Predicting an Intersection of a Linear Trend	Idgarad	Microsoft Excel Programming	4	22nd May 2007 04:40 PM
Linear Regression using the TREND function	scarlett1	Microsoft Excel Worksheet Functions	2	26th May 2006 03:04 PM
How do I anchor one end of a linear trend line?	=?Utf-8?B?V2lsbGlhbSBTcHVybG9jaw==?=	Microsoft Excel Charting	3	15th Jan 2006 08:06 PM
linear trend lines	bonzo	Microsoft Excel Charting	2	14th Dec 2003 02:54 PM