On 19 Mar 2006 07:26:37 -0800, "
wrote:
Hi
I have a column in my sheet that fills in progressively over a season
as team results are entered.
This particual column will show d for a goal-less draw (0-0), D for a
score draw (1-1, 2-2 etc) and W or L for Win/Loss
I'd like to show the last 6 game 'form' in this format: W,L,W,W,d,D
using that column
Any suggestions gratefully received
Thanks in advance
Neil
Assume the result is in A1 and the scores are in A2:An
Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr
Then use the formula:
=MCONCAT(OFFSET(A1,COUNTA(A2:A100),,-6),",")
--ron