# EXTREMELY Easy Question

#### Lucky707

##### New Member
Let's say cells C1 through J1 contained numbers.

C1, D1, E1, F1, G1, H1, I1, J1

In some cell... D56, I want it to return teh value from C1 to J1 that is the largest ... yes, that is easy...

In cell D57, I want it to return the value that is SECOND LARGEST

In cell D58, the third largest

And in cell D59, the fourth largest

hwo would I do it?

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You're going to get a better answer than this but here is what I would do:

Copy each cell into the the cells D56, D57 etc.

The record a macro in which you highlight those cells (D56, D57...) and do a sort.

Then put in a button and attach the macro to it.

The button can say "Sort from highest to lowest"

OK, this is lame but it's all I've got and it WOULD work.

Ned

Thanks, found an answer though when I searched (involving LARGE).

Tougher Question:
L115 contains a number from 2 to 81.

K117:K121 contain the following:
K117 = INDIRECT("A" & L115) ... the A column is a name/word.
K118:K121 are all a single word. K118 is =INDEX(C1:J1,MATCH(L118,C2:J2,0)), K119 is the same but replace L118 with L119... K120 and K121 are the same.

I want K118 to be =INDEX(C1:J1,MATCH(L118,Cn:Jn,0))
where n is the number in L115.

Similarly, L118:L121 contain the 1st to 4th largest numbers... L118 is =LARGE(B2:J2,1) ... I want it to be =LARGE(Bn:Jn,1) where once again n is the number in L115.

How to do that?

Replies
3
Views
149
Replies
2
Views
157
Replies
3
Views
142
Replies
4
Views
544
Replies
3
Views
374

1,196,053
Messages
6,013,118
Members
441,749
Latest member
batel19

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back