also this array formula work for me..
=INDEX(tbl, SMALL(IF(SMALL(IF(COUNTIF($B$7:B7, tbl)+ISBLANK(tbl)=0,
COUNTIF(tbl, "<"&tbl)+1, ""), 1)=IF(ISBLANK(tbl), "", COUNTIF(tbl,
"<"&tbl)+1), ROW(tbl)-MIN(ROW(tbl))+1), 1), MATCH(MIN(IF(COUNTIF($B$7:B7,
tbl)+ISBLANK(tbl)>0, "", COUNTIF(tbl, "<"&tbl)+1)),
Hi
Use follo formula, its not an array one..
=SMALL(tbl,ROWS($B$2:B2))
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 5:15 PM, Eddie wrote:
> Hi,
> I'd like to use the following array formula to sort numerical values
> rather than
