Define a macro button which finds longest chain (TRUE or FALSE), its longest length number in digits and Initial index(starting row). This questions refer to the image001 attached.
I have no knowledge of VBA Macro.
The image contains list of datapoints starting from any row. The output of the macro should point to the first element of the list if the datapoint is starting from 4. The initial index should be 4 and the max length of the array should be displayed.