| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create a trend formula with range that changes
I created a trend formula that works, but I want to make the range change as
I add more columns to the source data. Here is an example: TREND(B3:X3,B1:X1,Y1,TRUE) row 3 contains the raw data (cells B3 - X3) row 1 contains the refrence which is 1 -23 Now I'd run a new raw report and the data would extend to column Y. . . how do I set up the trend formula so that it automatically changes from B3:X3 to B3:Y3? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Trying to create formula to give range of stan.deviations of mean | Excel Discussion (Misc queries) | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Threaded Mode
