Results 1 to 8 of 8

Thread: Function to identify 'Path' of Superseded Items

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte jilbobagins's Avatar
    Join Date
    Apr 2019
    Excel Version

    Function to identify 'Path' of Superseded Items

    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??

    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.jpg 
Views:	8 
Size:	98.0 KB 
ID:	10638  
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts