Need help with correct formula please?

Question

What forumla can I use in Column C to base a number around Columns A &amp; B, cant describe fully how I want it but this the result I am wanting. Column B is in format DD/MM/YYYY&nbsp;Column A&nbsp; &nbsp; &nbsp;Column B&nbsp; &nbsp; Column C100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/04/2022&nbsp; &nbsp; &nbsp; 1100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2022&nbsp; &nbsp; &nbsp;1100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/04/2022&nbsp; &nbsp; &nbsp; 2100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/04/2022&nbsp; &nbsp; &nbsp; 2101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/04/2022&nbsp; &nbsp; &nbsp;1101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/04/2022&nbsp; &nbsp; &nbsp; 1102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;06/04/2022&nbsp; &nbsp; &nbsp; 1102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07/04/2022&nbsp; &nbsp; &nbsp; &nbsp;2102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07/04/2022&nbsp; &nbsp; &nbsp; &nbsp;2102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07/04/2022&nbsp; &nbsp; &nbsp; &nbsp;2103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/04/2022&nbsp; &nbsp; &nbsp; &nbsp;1103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/04/2022&nbsp; &nbsp; &nbsp; &nbsp;1103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/04/2022&nbsp; &nbsp; &nbsp; &nbsp;2

hansvogelaar · Answer

alexw94&nbsp;
Can you explain this?
&nbsp;
102 07/04/2022 2
102 07/04/2022 3
102 07/04/2022 3

alexw94 · Answer

Sorry, that was a mistake. I have changed the original post. Well spotted!

hansvogelaar · Answer

alexw94&nbsp;
Assuming that the data begin in row 2, enter the following formula in C2, then fill down:
&nbsp;
=IF(A2&lt;&gt;A1,1,C1+(B2&lt;&gt;B1))

Forum Discussion

Need help with correct formula please?

Share

Resources