Sorting multiple columns using formulas only

I am trying to mimic the sort and filter function using a formula for multiple columns, using the numeric values in descending order. See example attached.

(Column A) contains a range of text values.
(Column B) contains a range of unsorted numbers.

I am able to sort the numerical values in descending order, using the LARGE and ROW functions as shown in the following formula (in cell G2):

=LARGE($B$2:$B$17,ROW()-ROW($G$2)+1)

Now I would like to find a way of having the text values correspond with the sorted numerical data in the next column (H2). Can anyone help?

Try this

=INDEX($A$4:$A$19,MATCH(G4,$B$4:$B$19,0)+COUNTIF($G$4:G4,G4)-1) dragged down
Does that work for you?

Hey ChemistB,

For most part the formula you provided worked. Most of the cells text copied accurately, though there was one error and I can't figure out why. I've copied your formula into the attached spreadsheet, and have highlighted the error. Maybe you can let me know why this didn't work out completely.

I am now thinking that this error has to do with the fact that the array needs the values to be sorted in ascending order so that the duplicates are right below each other so that the countif portion works. Let me know if this is accurate, and if there is a way of doing this without having to sort the initial data.

That's correct mm. I assumed that, as per your example, the ranking was initially sorted from low to high. Beaunydal has aptly provided 2 solutions for non-sorted systems.

Thanks to everyone for the assistance with this problem. I have utilized the solution provided, and everything works perfectly now. Thanks again. mm_crown

XXX7

Pls start your own thread-as per forum rules- explaining of course much more which is your issue.