a separate column that is a sorted list of another column

Originally Posted by simkhovich

i have been using this formula that i copied online however it only works for 15 rows and i need 55 is there a simple method to do this?

=INDEX($A$2:$A$15,MATCH(SMALL(IF(ISBLANK($A$2:$A$15),"",IF(ISNUMBER($A$2:$A$15),COUNTIF($A$2:$A$15,"<"&$A$2:$A$15),COUNTIF($A$2:$A$15,"<"&$A$2:$A$15)+SUM(IF(ISNUMBER($A$2:$A$15),1,0))+1)),ROW(A1)),IF(ISBLANK($A$2:$A$15),"",IF(ISNUMBER($A$2:$A$15),COUNTIF($A$2:$A$15,"<"&$A$2:$A$15),COUNTIF($A$2:$A$15,"<"&$A$2:$A$15)+SUM(IF(ISNUMBER($A$2:$A$15),1,0))+1)),0))

Is this what your desired result is?

=INDEX($A$2:$A$55,MATCH(SMALL(IF(ISBLANK($A$2:$A$55),"",IF(ISNUMBER($A$2:$A$55),COUNTIF($A$2:$A$55,"<"&$A$2:$A$55),COUNTIF($A$2:$A$55,"<"&$A$2:$A$55)+SUM(IF(ISNUMBER($A$2:$A$55),1,0))+1)),ROW(A1)),IF(ISBLANK($A$2:$A$55),"",IF(ISNUMBER($A$2:$A$55),COUNTIF($A$2:$A$55,"<"&$A$2:$A$55),COUNTIF($A$2:$A$55,"<"&$A$2:$A$55)+SUM(IF(ISNUMBER($A$2:$A$55),1,0))+1)),0))

Originally Posted by simkhovich

something like that but it didn't work if it helps here is the excel filehttps://www.dropbox.com/s/zquk8w2hyo...1%29.xlsb?dl=0 the formula is under sorted list column

plz see attached file, does that work?

Originally Posted by simkhovich

thank man if you don't mind explaining why didn't it work in first place?

It's an array formula, after writing the formula press CTRL SHIFT ENTER simultaneously.