Let's say I were to fill down, giving me say... 100 sets of 8 random numbers from row 1 to row 100.

Let's say I have five boxes.

[A]

[C]

[D]

[E]

In box A, I will type a number from 1 to 100. Call it n.

In box B, I want the largest number in row n.

In box C, I want the second largest number in row n.

In box D, I want the third largest number in row n.

In Box E, I want the fourth largest number in row n.

How to do that?

[C]

[D]

[E]

In box A, I will type a number from 1 to 100. Call it n.

In box B, I want the largest number in row n.

In box C, I want the second largest number in row n.

In box D, I want the third largest number in row n.

In Box E, I want the fourth largest number in row n.

How to do that?