I sliced and diced both the table you have in the above post and the uploaded workbook , but I could not figure out the logic of your request.

It seems that your data is in random order. After some sorting, I was able to find all the Asset numbers you listed in the first post. But however I sorted, I could not get the results you show by stopping at the first matching From and To.
1103743,1104288,5708836,5710469,1103815,1103819,1103775,1103785,1104325,110 4362
1103743
 05-08-043-01 W4 08-07-043-01 W4 1103775
 05-08-043-01 W4 02-07-043-01 W4
1103775 05-08-043-01 W4 02-07-043-01 W4 1104288
 05-08-043-01 W4 03-17-043-01 W4
1103785 05-08-043-01 W4
 12-08-043-01 W4 1104325
 05-08-043-01 W4 03-17-043-01 W4
1103815 05-08-043-01 W4 06-08-043-01 W4 1103819
 05-08-043-01 W4
 05-08-043-01 W4
1103819 05-08-043-01 W4
 05-08-043-01 W4 5710469
 05-08-043-01 W4
 05-08-043-01 W4
1104288
 05-08-043-01 W4 03-17-043-01 W4 1103815
 05-08-043-01 W4 06-08-043-01 W4
1104325
 05-08-043-01 W4 03-17-043-01 W4 5708836
 05-08-043-01 W4 06-08-043-01 W4
1104362 05-08-043-01 W4 08-07-043-01 W4 1103743
 05-08-043-01 W4 08-07-043-01 W4
5708836 05-08-043-01 W4 06-08-043-01 W4 1104362
 05-08-043-01 W4 08-07-043-01 W4
5710469 05-08-043-01 W4
 05-08-043-01 W4 1103785
 05-08-043-01 W4 12-08-043-01 W4


The Left Hand table is sorted by From then Asset.The Right hand is sorted by From then To.
The Bold Cells are the matching From LSD and To LSD.

Where's the logic?