MATCH list without blanks.

[twl2009]

Hi,

I have a sheet with upto 10000 rows of data, on another sheet I need to have a draggable formula to make a list of all the values in col C where Col AD has a positive number. I would like this list to be without blanks as out of the 10000 rows there will not often be more than 10-20 values to list.
Preferably this list would be ordered by the number is held in the 3rd-6th digits of the value (ie mid(X,3,4)), lowest first.

Is this possible.

Thanks
Twl

 

[twl2009]

I really thought someone would be able to help with this one. Im really struggling to get this working. I can use more than 1 column to achieve this if that helps.
Twl

 

[Aladin Akyurek]

Control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($C$2:$C$200,SMALL(IF(ISNUMBER($D$2:$D$200),IF($D$2:$D$100>0,ROW($C$2:$C$200)-ROW($C$2)+1)),ROWS($1:1))),"")

 

[twl2009]

Thats fantastic thanks

 

[Aladin Akyurek]

Thats fantastic thanks

You are welcome.