coffeenazi
New Member
- Joined
- Aug 17, 2010
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi all, I have a dataset that consists of multiple unique "Activities", that are grouped within a multilevel list like this:
The values under each of these heading are very detailed text strings. for example, some of the Actions have over 380 characters in the text string.
I am trying to write a formula that will create a dynamic multilevel list number in Column D, unique for each Activity but nested under that Activity's Deliverable, Action, and Focus area.
All help would be greatly appreciated, and thank you in advance!
Focus area (Column A) | Action (Column B) | Deliverable (Column C) | Activity (Column D) |
1 | 1.1 | 1.1.1 | 1.1.1.1 |
1 | 1.2 | 1.2.1 | 1.2.1.1 |
1 | 1.2 | 1.2.1 | 1.2.1.2 |
2 | 2.1 | 2.1.1 | 2.1.1.1 |
2 | 2.1 | 2.1.1 | 2.1.1.2 |
2 | 2.1 | 2.1.1 | 2.1.1.3 |
The values under each of these heading are very detailed text strings. for example, some of the Actions have over 380 characters in the text string.
I am trying to write a formula that will create a dynamic multilevel list number in Column D, unique for each Activity but nested under that Activity's Deliverable, Action, and Focus area.
All help would be greatly appreciated, and thank you in advance!