I'm looking for a way to make a average value out of values below 4. Also out of the values below 4 I need to choose the values between 25% and 75% from the total number of values.
Example
A row with those values...
4
4
2.5
3.0
2.0
2.5
4
...would result in an other row with the average
3.5
or
4
4
4
3.0
3.0
1.0
3.0
3.0
3.0
1
2.0
4
4
would result in the average:
2.5
Bookmarks