filtering numbers?

Originally Posted by Alex G

Hi NBVC
Think of the average (20) in column B as a sell order. Any market that reaches that number will trigger a sell signal. A formula that filters out figures higher than the column B average but includes the lower & negative numbers should work. So, a max value of 20 (B average) and all bellow needs to be entered.

Alex G

Tried the formula NBVC, didn't seem to work. Manually, the result worked out at 16.60.

Alex G