Creating a string of text from several cells

N

Neil G

This is the result of a motorcycle race, where a rider may be replaced
by a reserve if he falls for example.
So the actual match program might look like
A B C D E
1 Time Name Reserve Result
2 61.1 John FX Ole 1
3 Fred 3
4 Brian 2
5 Joe F

So, I want to put this into one string, which would look like this, when 3
is the winners points (ranking 1), 2 for second, 1 for 3rd, 0 for 4th. (F/FX
denote non finishers who need to be included):

Fred, Brian, Ole, Joe (F), John (FX), 61.1

Is that possible using INDEX? or do I need some other method?

Thanks to anyone who can suggest an answer

Neil.
 
N

Neil G

Ooops, awful alignment
Time (61.1) is column A, Names (John Fred etc), are under column B, FX is
column C, Reserve (Ole) is column D, Result (3,2,10,F etc) column E

Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top