Multiboard
New Member
- Joined
- Mar 7, 2024
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi Everyone, I hope you can help me in expanding a formula please.
I have a sheet with 3 columns; Column A=Names in alphabetic order, Column B=Date the task was completed and column C=will need to show the daily tasks sequentially and for each name. I hope the example below makes sense. I'm currently using, in cell C2, =COUNTIFS($A$2:$A2,"Anna", $B$2:$B2,$B2), which only works with Anna and I really can't find a way to add the other names in the formula.
A B C
Anna 01.01.25 1
Anna 01.01.25 2
Anna 02.01.25 1
Bill 01.01.25 1
Bill 03.01.15 1
Bill 03.01.25 2
Carter 01.01.25 1
Carter 01.01.25 2
Carter 02.01.25 1
Carter 02.01.25 2
Carter 02.01.25 3
Any help, would be highly appreciated.
Thank you in advance.
I have a sheet with 3 columns; Column A=Names in alphabetic order, Column B=Date the task was completed and column C=will need to show the daily tasks sequentially and for each name. I hope the example below makes sense. I'm currently using, in cell C2, =COUNTIFS($A$2:$A2,"Anna", $B$2:$B2,$B2), which only works with Anna and I really can't find a way to add the other names in the formula.
A B C
Anna 01.01.25 1
Anna 01.01.25 2
Anna 02.01.25 1
Bill 01.01.25 1
Bill 03.01.15 1
Bill 03.01.25 2
Carter 01.01.25 1
Carter 01.01.25 2
Carter 02.01.25 1
Carter 02.01.25 2
Carter 02.01.25 3
Any help, would be highly appreciated.
Thank you in advance.