Lookup All Corresponding Values Match Criteria In Adjacent Column Array Formula

[LalitPandey87]

First thing:
I have placed a condition in formula which is:

($M$1:$M$35068 <> 0)

because you told me that you only want to see those records which are not 0 in column name "OPEN_INT"

Second thing:
If you need above conditon as well then you need to select more rows and then press F2 and Press CSE(Ctrl + Shift + Enter) as you are using formula only in range W14:W32 you need to resize it for all results.

If both is not the same what you are asking for then why don't you send me the result for all stocks manually which you want me to get using formula may be it will give me better clearity.

And i am talking about the formula in your file which you just sent me.