Sort column high to low ignoring zeros.

[TimeCreature]

Can anyone let me know if this is possible and how i might achieve it
The following numbers are automatically gathered using a COUNTIF function from another sheet.
3
4
7
1
2
0
0

The above figures are located in cells C9:C15 how can i get these to automatically copy over to cells D9:D13 arranged with the highest number in D13.

 

[pgc01]

Hi
Welcome to the board.

This is one possible solution.

The numbers in C9:C15 are written in ascending order in D9:D15. Zeros are not displayed.

In D9:

=IF(ROW(C9)-ROW($C$9)>=COUNTIF($C$9:$C$15,"<>0"),"",INDEX($C$9:$C$15,MATCH(SMALL(IF($C$9:$C$15<>0,$C$9:$C$15),1+ROW(C9)-ROW($C$9)),$C$9:$C$15,0)))

This is an array formula and so MUST be entered with CTRL+SHIFT+ENTER and not just ENTER.
Copy down until D15

Hope this helps
PGC