# Need an Array Formula to Sort a 2-column Table

1. ## 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

Thank you.

Problem.JPG  Register To Reply

2. ## Re: Need an Array Formula to Sort a 2-column Table

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  Register To Reply

3. ## Re: Need an Array Formula to Sort a 2-column Table

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.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 