Need an Array Formula to Sort a 2-column Table

Dear All:

I have this 2-Column Table I needed sorted (and be automatically) updated.

I have done this before using 'Array Formulae' & the Excel function [SMALL] but just can't remember how I did it.

The Range A1:A12 needs to be sorted in 'Descending Order' based on the values in Range B1:B12 and the result put into Range C1:D12

Could someone please help.

Thank you.

Problem.JPG

D1=LARGE(B$1:B$9,ROWS(D$1:D1))
C1=INDEX(A:A,SMALL(INDEX((B$1:B$9<>D1)*10^10+ROW(A$1:A$9),0),COUNTIF(D$1:D1,D1)))
Try this and copy towards down

Thank you very much for your instant help. Much appreciated.

I have corrected a slight mistake in the formula you wrote. B$12 instead of B$9. (The columns have 12 cells each)

Thanks once again Siva.