Hi
A previous thread explained how to pull non-zero values from a column of values
http://www.mrexcel.com/forum/showthread.php?p=1862091#post1862091
The code I then used from this thread is as follows:
=IF(ROWS(B$1:B1)>COUNTIF(A$1:A$1200,">0"),"",INDEX(A$1:A$1200,SMALL(IF(A$1:A$1200>0,ROW(A$1:A$1200)-ROW(A$1)+1),ROWS(B$1:B1))))
The logic behind it is explained in the thread....
This code works great but I need it to apply to negative numbers as well. I posted the question there but have not got a reply as yet.
Would anyone be able to figure this out for me? I would be very grateful!
A previous thread explained how to pull non-zero values from a column of values
http://www.mrexcel.com/forum/showthread.php?p=1862091#post1862091
The code I then used from this thread is as follows:
=IF(ROWS(B$1:B1)>COUNTIF(A$1:A$1200,">0"),"",INDEX(A$1:A$1200,SMALL(IF(A$1:A$1200>0,ROW(A$1:A$1200)-ROW(A$1)+1),ROWS(B$1:B1))))
The logic behind it is explained in the thread....
This code works great but I need it to apply to negative numbers as well. I posted the question there but have not got a reply as yet.
Would anyone be able to figure this out for me? I would be very grateful!