Creating a string of text from several cells

  • Thread starter Thread starter Neil G
  • Start date Start date
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.
 
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

Back
Top