hello and thank you for opening my message
I am a little stuck, I have tried for hours to solve it
I have column A with 1997 and Column B with 2004 in
I need help producing a formula that will look at A1 & B1 and report all the missing years in the sequence in the adjacent columns c1 d1 e1 etc.
it is also required to do it to A2 and B2, A3 and B3 and so on.
I hope someone can help me and I appreciate any pointers you may have.
James
I am a little stuck, I have tried for hours to solve it
I have column A with 1997 and Column B with 2004 in
I need help producing a formula that will look at A1 & B1 and report all the missing years in the sequence in the adjacent columns c1 d1 e1 etc.
it is also required to do it to A2 and B2, A3 and B3 and so on.
I hope someone can help me and I appreciate any pointers you may have.
James