Permanently sort a Col depending on Colour

So the values dont need to be sorted, sicne you havent sorted them, you simply want red at the top (in any order) and then non-red.

in row D2
=IFERROR(INDEX($A$2:$B$24,AGGREGATE(15,6,ROW($A$2:$A$24)/((ISNUMBER((SEARCH("1",A$2:A$24))))),ROWS(A$2:A2))-(2-1),COLUMN()-3),"")
copy to E2
and copy down for as many rows as you have in column A

Hello,

I might be missing something, it's simply returning the attached

Ah, now I've tested it, it will simply return the values in red, not the others though it does return the actual values, ie I'm not getting a 0 at all.

Either try again (it does work) or post the file where you're getting 0.

No, my mistake, as above this will only return red values, I dont think this solution will work

Please try at D2:E25

=IF($A2<>"",INDEX(A:A,IFERROR(AGGREGATE(15,6,ROW($A$2:$A$99)/ISNUMBER(FIND(1,$A$2:$A$99)),ROWS(D$2:D2)),AGGREGATE(15,6,ROW($A$2:$A$99)/ISERROR(FIND(1,$A$2:$A$99)),ROWS(D$2:D2)-COUNT(INDEX(FIND(1,$A$2:$A$99),))))),"")

or just sort on cell color, selcet A2 >Ribbon Data > sort and set as below
sort.jpg

Thank you!

Please see attached.