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

	A	B
1	15/12/15	L
2	16/12/15	W
3	17/12/15	D
4	18/12/15	W
5	19/12/15	W
6	20/12/15	L

<tbody>
</tbody>

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