Hi
it is possible BUT is only feasible for small amount of records (as it's
quite slow). Depending on your data structure you may try the following array
formulas (entered with CTRL+SHIFT+ENTER): These formulas sort mixed data
types (text, numbers, boolean values, error codes -> If you have simpler data
- e.g. only numbers - post back as you can simplify the formulas))
(assuming your data is in A3:A20) try:
B3:
=INDEX(IF(ISBLANK($A$3:$A$20),"",$A$3:$A$20),MATCH(SMALL(COUNTIF(
$A$3:$A$20,"<"&$A$3:$A$20)+0*BigNumber*ISNUMBER($A$3:$A$20)+1*BigNumber*ISTEXT($A$3:$A$20)+2*BigNumber*ISLOGICAL($A$3:$A$20)+3*BigNumber*ISERROR($A$3:$A$20)+4*BigNumber*ISBLANK($A$3:$A$20),ROW(1:1)),COUNTIF($A$3:$A$20,"<"&$A$3:$A$20)+0*BigNumber*ISNUMBER($A$3:$A$20)+1*BigNumber*ISTEXT($A$3:$A$20)+2*BigNumber*ISLOGICAL($A$3:$A$20)+3*BigNumber*ISERROR($A$3:$A$20)+4*BigNumber*ISBLANK($A$3:$A$20),0))
B4:
=INDEX(IF(ISBLANK($A$3:$A$20),"",$A$3:$A$20),MATCH(SMALL(COUNTIF(
$A$3:$A$20,">"&$A$3:$A$20)+3*BigNumber*ISNUMBER($A$3:$A$20)+2*BigNumber*ISTEXT($A$3:$A$20)+1*BigNumber*ISLOGICAL($A$3:$A$20)+0*BigNumber*ISERROR($A$3:$A$20)+4*BigNumber*ISBLANK($A$3:$A$20),ROW(1:1)),COUNTIF($A$3:$A$20,">"&$A$3:$A$20)+3*BigNumber*ISNUMBER($A$3:$A$20)+2*BigNumber*ISTEXT($A$3:$A$20)+1*BigNumber*ISLOGICAL($A$3:$A$20)+0*BigNumber*ISERROR($A$3:$A$20)+4*BigNumber*ISBLANK($A$3:$A$20),0))
and copy this formula down. Bignumber is a large number which is > than your
number of rows. e.g. define a name for this and set the name equatl to 70000
