Jim wrote...
Great answer to my questions. Thank you. One more follow up. How do I get
the nth value to change when I am dragging down the cells? The nth is
remaining the same.
....

If you want all values in some range (which I'll denote rng) in
descending order, it's more efficient to *avoid* using the LARGE
function. If the largest value were to appear in cell E1 with the next
largest in E2, etc., try the following if you don't want duplicates.

E1:
=MAX(rng)

E2 [array formula]:
=MAX(IF(rng<E1,rng,-1E+300))

Fill E2 down as far as needed. If you want duplicates, then maybe LARGE
would be the function to use.

E1:
=LARGE(rng,ROWS(E$1:E1))

Fill E1 down as far as needed.