Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions |