Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming

teepee[_4_] teepee[_4_] is offline

external usenet poster

Posts: 27

Range of averages

Can anyone help

I have a value for T1 and a value for T11 (which might be greater or
lesser.)

I want to fill T2 through T10 with a series of averages to smoothly fill the
gap so to speak.

So if T1 were 1 and T11 were 11, the series would count out 1 to 11
And if T1 were 22 and T2 were 2, then the series would count backwards from
22 to 2, even number only.

Anyone know how?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing the range for averages with out changing the formula.	JessLRC	Excel Worksheet Functions	0	April 20th 10 03:10 PM
Averages	sailor	Excel Discussion (Misc queries)	3	September 8th 09 05:13 PM
Averages	Help	Excel Discussion (Misc queries)	3	August 25th 09 03:28 PM
Averages	Jimenda	Excel Worksheet Functions	1	December 21st 05 11:24 PM
Range of averages	teepee	Excel Discussion (Misc queries)	4	October 16th 05 09:53 AM

All times are GMT +1. The time now is 05:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us