hi there


i have data laid out like this:


----------------------------------------------------------------------------------------------
Jan Feb Mar Apr May Jun Jul
A 10 11 12 13 14 15 16
B 10 11 12 13
C 10 11 12
D 10 11 12
----------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------


I want to write a formula that will give me the start & end months of each
row in a table like this:


-----------------------------------------------------------------------------------------------
Start End
A
B
C
D
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

so eventually it will look like this



-----------------------------------------------------------------------------------------------
Start End
A Jan Jul
B Feb May
C May Jul
D Jan Mar
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


so far, my thinking only takes me as far as using some sort of Index
formula, but i dont know how to make it work

any help gratefully recieved, let me know if youy need anymore info


cheers

jb2010