Hi everyone,
I have a table with 3 columns: A:ID, B:Type and C:Name. Column 'Type' is a dropdown menu that contains: P,T,S (short for Phase, Task and Subtask)
I need a formula in column A that generates sequential numbers starting from 1 based on the selection in column B
This is a sample table with the expected results in column A. As you can see, T (task) is a subset of P (phase) and S (subtask) is a subset of T.
numbering.png
Bookmarks