How to order a row into a different row

[ligerdub]

I'm looking to order a row of numbers and to sort them by value in a different row. Essentially I'd be looking to do this to ensure that I can change the figures in the data and the changes are traced in a different row.

In the attached file I'd be looking to order the figures showing in row 14 and display the order in row 25.

Would appreciate any help.

Thanks.

[zbor]

Do you mean this in B25: =LARGE(B$14:B$22, ROWS(B$25:B25))

[ligerdub]

Almost thanks.

Not quite though.

I want to rank the numbers in row 14 into row 25, i.e. to display B25 to be the highest value in row 14, C25 would be the 2nd highest in row 14, D25 the 3rd highest and so on.

[zbor]

Then this: =LARGE($B14:$P14, COLUMNS($B25:B25)) in B25 and pull to the right

[ligerdub]

That's perfect, thanks a lot.

[mahju]

Hi

Check this one
Regard