I have a list of to-do's and want to number them based on grouping. I would think this would be a fairly easy formula to build but my knowledge of Excel is limited.
Below is an example of WHAT I WOULD LIKE (row 1 is the column this data can be found in; row 2 is the name of the column; row 3 begins sample data):
<tbody>
</tbody>
Note: I may add a to-do to the bottom of the list; e.g., 01.01 may end up in row 50 while all the other "01.01 to-dos" are in rows 3:4. Therefore the formula cannot just check to see if the cell in column G above is the same.
I built the first part of the formula which is to extract the first 5 characters from the ### column G: =left(G2,5). I would then like to add the unique number after those 5 characters extracted (as shown above in the table).
I need help building the rest of the formula.
Thanks so much!
Below is an example of WHAT I WOULD LIKE (row 1 is the column this data can be found in; row 2 is the name of the column; row 3 begins sample data):
Column B | Column G |
"#" | "To-Do" |
01.01.1 | 01.01 Clean House |
01.01.2 | 01.01 Clean House |
01.02.1 | 01.02 Wash Carpet |
01.02.2 | 01.02 Wash Carpet |
01.02.3 | 01.02 Wash Carpet |
02.01.1 | 02.01 Clean Car |
02.02.1 | 02.02 Mow Lawn |
02.02.2 | 02.02 Mow Lawn |
<tbody>
</tbody>
Note: I may add a to-do to the bottom of the list; e.g., 01.01 may end up in row 50 while all the other "01.01 to-dos" are in rows 3:4. Therefore the formula cannot just check to see if the cell in column G above is the same.
I built the first part of the formula which is to extract the first 5 characters from the ### column G: =left(G2,5). I would then like to add the unique number after those 5 characters extracted (as shown above in the table).
I need help building the rest of the formula.
Thanks so much!