Sort Data Highest first

[ExcelRoy]

Hi everyone,

I have the following array formula

=IFERROR(INDEX($Z$13:$Z$512,MATCH(SMALL(NOT($Z$13:$Z$512="")*IF(ISNUMBER($Z$13:$Z$512),COUNTIF($Z$13:$Z$512,"<="&$Z$13:$Z$512),COUNTIF($Z$13:$Z$512,"<="&$Z$13:$Z$512)+SUM(--ISNUMBER($Z$13:$Z$512))),ROWS($Z$13:Z13)+SUM(--ISBLANK($Z$13:$Z$512))),NOT($Z$13:$Z$512="")*IF(ISNUMBER($Z$13:$Z$512),COUNTIF($Z$13:$Z$512,"<="&$Z$13:$Z$512),COUNTIF($Z$13:$Z$512,"<="&$Z$13:$Z$512)+SUM(--ISNUMBER($Z$13:$Z$512))),0)),"")

This works but I would like it sort highest first? what would I need to change in order to do this?

Any help appreciated

Many thanks

 

[shg]

Change SMALL to ...