Count when number moves to next full number

[mckrod]

10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated.

See attached spreadsheet....

I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green)

In row 71 and 72 (in yellow), I would like to release the corresponding packages by a month BUY ONLY every time a full number( not a decimal) is passed in row 54 and 55 (in yellow)

I would like to add the formulas to row 71/72 (in yellow) so that they will automatically change if row 54/55 change.

I have added sample answers of what it should look like in row 71/72

Many thanks in advance!

 

[Eric W]

Welcome to MrExcel!

How about:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2			0.0	0.3	0.8	0.9	1.3	1.7	2.1	2.6	3.1	3.8	4.5	5.2
3			0.4	1.3	2.1	3.1	4.3	5.5	6.7	8.1	9.8	11.7	13.8	16.0
4
5
6							1		1		1		1	1
7				1	1	1	1	1	1	2	1	2	2	3
Sheet3

Cell Formulas
Range	Formula
C6:N7	C6	=IFERROR(1/(1/(INT(C2)-INT(B2))),"")

Please note that this site has a tool called XL2BB (Excel to Bulletin Board), which allows you to put a sample of your worksheet in your post. It makes it so that the helpers here can copy your data directly without having to manually retype everything from a picture. You're likely to get faster/better answers if you use it. There's a link in my signature, or in the reply box, it's easy to set up and use.

 

[mckrod]

Eric, you are an absolute legend! This is spot on - thank you so much! I wasted so much of my time attempting this.

I can't thank you enough. I will make sure to use the XL2BB next time.

Have a nice evening!

 

[Eric W]

Happy to help! Thanks for the feedback.

 

[Toadstool]

Hi McKRod,

Eric beat me!

MCKrod.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
1		01-Jan-21	01-Feb-21	01-Mar-21	01-Apr-21	01-May-21	01-Jun-21	01-Jul-21	01-Aug-21	01-Sep-21	01-Oct-21	01-Nov-21	01-Dec-21
2	Cumulative
3	n1	0	0.3	0.6	0.9	1.3	1.7	2.1	2.6	3.1	3.8	4.5	5.2
4	n2	0.4	1.3	2.1	3.1	4.3	5.5	6.7	8.1	9.8	11.7	13.8	16
5
6	Sold
7	n1					1		1		1		1	1
8	n2		1	1	1	1	1	1	2	1	2	2	3
Sheet1

Cell Formulas
Range	Formula
D1:N1	D1	=EOMONTH(C1,0)+1
D7:N8	D7	=IF(INT(D3)-INT(C3)<1,"",INT(D3)-INT(C3))