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
Bookmarks