| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula
Can anyone assit with a formula for detirmining if a number in a group of 20 is one of the lowest 8. I have been trying "=IF(F1<MEDIAN(F$1:F$20),F1,0)" This seems to give me one of the lowest 10 out of the group of 20.
Any suggestions would be greatly appreciated. Thanking you in anticipation Garry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Threaded Mode
