#### S.H.A.D.O.

##### Well-known Member

- Joined
- Sep 6, 2005

- Messages
- 1,915

I would like to

This achieves the correct result for the first number, but I can't seem to be able to get the concatenate to work.

So basically, whatever the two largest numbers in

I know I could use:-

but I thought there might be an easier way.

Thanks in advance.

**Concatenate**the two largest numbers in cells**M7:M55**that reflect the numbers in cell**B7:B55**.This achieves the correct result for the first number, but I can't seem to be able to get the concatenate to work.

Code:

`=INDEX(B7:B55,MATCH(LARGE(M7:M55,1),M7:M55,0))`

So basically, whatever the two largest numbers in

**M**are, it returns the values in**B**.I know I could use:-

Code:

`=INDEX(B7:B55,MATCH(LARGE(M7:M55,1),M7:M55,0))&" "&INDEX(B7:B55,MATCH(LARGE(M7:M55,2),M7:M55,0))`

but I thought there might be an easier way.

Thanks in advance.

Last edited: