| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula- find min value in range, then average that value with one value on each side
Can anyone please help with an excel formula to find the minimum value
in a row range, then average that value with one value on each side? I was currently using this formula to find the 4 smallest values and average them together, but now I want to find the smallest and average consecutive values (one on each side) =AVERAGE(SMALL('Sheet1'!$C$9:$L$9,{1,2,3,4})) Hope this makes sense. Thank you in advance for your help. Wendy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find out average even rows in a particular range | Excel Worksheet Functions | |||
| Formula to find average of the best 2 of 3 scores | Excel Worksheet Functions | |||
| select date range then find average of values in another cell | Excel Worksheet Functions | |||
| Array Formula to find Average Return | Excel Discussion (Misc queries) | |||
| find an average from a range, utilizing all data 0 | Excel Worksheet Functions | |||
![Wendy[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
