Snasui Excel Forum

Hi Dear,

I have data layout a2:b6 I need to sort it by max numbers.i need a formula not built in feature.
I attached a sample with result in color cells

Thanks

Try this,

1. B12
   =LARGE($B$2:$B$6,ROWS(B$12:B12))
   Enter > Copy down
2. A12
   =INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$6)/($B$2:$B$6=B12),COUNTIF(B$12:B12,B12)))
   Enter > Copy down

Thanks
but how we don't use helper column?

You can do that with default feature or VBA not a formula.

Ok thank you

snasui wrote: Sun Mar 21, 2021 7:38 am You can do that with default feature or VBA not a formula.

The above quote means your result in the same place of the source.

If you need only one formula, can use this formula in A12.

=INDEX(A:A,MOD(AGGREGATE(14,6,$B$2:$B$6+ROW($B$2:$B$6)/1000,ROWS(A$12:A12)),1)*1000)

Enter > Copy to B12 then down.

Thank you so much