Forum Discussion
Need help with correct formula please?
What forumla can I use in Column C to base a number around Columns A & B, cant describe fully how I want it but this the result I am wanting. Column B is in format DD/MM/YYYY Column A Column ...
Sorry, that was a mistake. I have changed the original post. Well spotted!
Assuming that the data begin in row 2, enter the following formula in C2, then fill down:
=IF(A2<>A1,1,C1+(B2<>B1))