jilbobagins
Member
- Joined
- Apr 11, 2019
- Messages
- 80
- Reaction score
- 0
- Points
- 6
- Excel Version(s)
- 2016
Hi All,
Please refer tables in attachment
I have a Table named "Changed" 'Blue' which details part number and the part number they've changed to. Sometimes there can only be one occurrence of a part changing, but on occasion that part its changed to also changes!
What im after from this is a method to identify by part what the latest possible part number it has changed to, how many times has it been through a change and the string of those change details (orange table example)
Im feeling its a List.Accumulate...but that beyond me .....maybe its easier than it looks??
Thanks
Please refer tables in attachment
I have a Table named "Changed" 'Blue' which details part number and the part number they've changed to. Sometimes there can only be one occurrence of a part changing, but on occasion that part its changed to also changes!
What im after from this is a method to identify by part what the latest possible part number it has changed to, how many times has it been through a change and the string of those change details (orange table example)
Im feeling its a List.Accumulate...but that beyond me .....maybe its easier than it looks??
Thanks