5 Most recent

[Fraserj]

Hello People,
I'm having a little bit of a problem, which i'm guessing is probably simple, but I just am overlooking it. Hopefully that is the case... (preferably not a macro as I am planning on using it on a mobile, which doesn't allow macros to work.)

But i'll give it a go anyway

I have a table which is shown below[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]15/12/15
[/TD]
[TD]L
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]16/12/15
[/TD]
[TD]W
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]17/12/15
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]18/12/15
[/TD]
[TD]W
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]19/12/15
[/TD]
[TD]W
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]20/12/15
[/TD]
[TD]L
[/TD]
[/TR]
</tbody>[/TABLE]

I need a formula which picks up the last 5 dates (column A) but transfers it to whatever is in column B but puts the conclusion into one cell(in this case WDWWL).

Any help would be truly appreciated

 

[gaz_chops]

Try

=INDEX(B2:B7,MATCH(LARGE(A2:A7,5),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,4),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,3),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,2),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,1),A2:A7,0))

 

[Fraserj]

Try

=INDEX(B2:B7,MATCH(LARGE(A2:A7,5),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,4),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,3),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,2),A2:A7,0))&INDEX(B2:B7,MATCH(LARGE(A2:A7,1),A2:A7,0))

Works perfectly, and your way is a lot more simpler than how I was trying to do it haha
Thank You... also Respect to you for replying so quickly

One question whilst I have your attention... Is there a way of Making Each letter "W" "D" and "L" become different colours but in that same cell, if not it's fine. I just wanted to learn how to do it

 

[gaz_chops]

You're welcome, I'm pretty sure you can't colour each character differently within one cell, but someone else may prove me wrong.

You could put the results in 5 separate cells then colour each!

 

[Fraserj]

It's ok... It's not essential... thank you anyway