find missing numbers in sequence and report them in adjacent cells

[jaamba123]

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

 

[Eric W]

Welcome to the forum.

If I understand correctly:

Excel 2012

	A	B	C	D	E	F	G	H	I
1	Year 1	Year 2	Years between
2	1997	2004	1998	1999	2000	2001	2002	2003
3	2010	2016	2011	2012	2013	2014	2015
4

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula C2 =IF($A2+COLUMNS($C2:C2)>=$B2,"",$A2+COLUMNS($C2:C2)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Put the formula in C2, then copy down and across as needed.

Hope this helps.a

 

[jaamba123]

My friend, you have made a very confused person happy.

I really appreciate your help and this was a very kind thing you have done.

it works flawless and I have what I require,

thank you again

James

 

[Eric W]

Happy to help.