EXTREMELY Easy Question

[Lucky707]

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?

 

[Ned Ludd]

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

 

[Lucky707]

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?

 

[Ned Ludd]

Who Knew?

Check out this thread. The Large Worksheet fuction. I tired it with your problem. It works.

http://www.mrexcel.com/board2/viewtopic.php?t=178772

Ned.