| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Daverage function with rows instead of colums.
I need to calculate a weekly moving average of prices by leverage from
information from a another sheet. An example of the sheet is below: Deal Co. A Co.B Co.C Week 1 1 3 Leverage Pricing 5.0x - 200 300 4.5x 250 125 400 4.0x 350 - 500 I need to create a table on another sheet that will calc. the weekly average price of each Leverage level. The new table looks like this: Leverage Average Price (wk1) Avg Price (wk2) 5.0x 4.5x 4.0x Can anyone help? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Row Sequencing | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| i want my excel colums to be rows | Excel Worksheet Functions | |||
| switch colums and rows | New Users to Excel | |||
Linear Mode
