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
 
Back
Top