J
JB2010
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
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