Share via

Adding numbers based on consecutive dates

Anonymous
2020-10-07T12:57:53+00:00

Hi,

I'm trying to add the 'Sum of Days' column for consecutive dates for the same 'Code'. This is proving to be a little challenging.

I would really appreciate if someone could help me out.

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-10-08T03:56:16+00:00

    Hi Shaun,

    You're welcome. I will try this one. Looks like it's a new set of data. I'll get back to you with an update.

    Thanks,

    Jen :)

    0 comments
  2. Anonymous
    2020-10-08T05:59:46+00:00

    Meanwhile, to filter the data by 'Year' and "Code", select the columns of data, go to Data Tab, click Filter.

    You may also refer to this link.

    https://support.microsoft.com/en-us/office/filt...

    Regards,

    Jen

    0 comments