Readjust the order of links in a corridor

[user90]

Please help me in writing the formula. Because of match first occurence it is getting repeated.

I have "From", "To" NODE IDs of road segments which are not in order and needs to be reordered. I found the two unique values which are first node and last node of the corridor and started with one.

Please see attached file.

Thank you very much in advance.

 

[NARAYANK991]

Hi ,

I am not sure this works ; please check thoroughly.

Narayan

 

[user90]

Narayan,

Awesome!!

I think this array formula itself solved the issue:

E3 =

{=IFERROR(INDEX($B$2:$B$33,MATCH(TRUE,IF($C$2:$C$33=E2,$B$2:$B$33<>D2),0)),INDEX($C$2:$C$33,MATCH(TRUE,IF($B$2:$B$33=E2,$C$2:$C$33<>D2),0)))}

Thank you very much.