Hello guys!
This forum has poven to be very useful when I'm having real troubles with Excel, so I hope you guys will be able to give me a hand this one time once again! Thank you in advance
)
My issue consists of a database of routes A-B-C-D. But sometimes there is A-B-D-C (A and B stay the same, but C and D are reversed, which is actually the same route but in the return direction). I would like to be able to identify such cases as the data consists of 10k entries and it is pretty much unhuman to start identifying them one by one...
In detail:
I've got Origin, Destination and up to three Connecting Points. Each of the five points has four components (four columns per point) - code, name, country, region/continent. And then the database gives specific details for each route in the last three columns. All in all, columns A-T define the route and U, V and W give details about the route.
I want to be able to identify reversed Connecting Points when Origin and Destination stay the same. If CP1 and CP2 are the same as CP2 and CP1 of another entry, it could identify that entry by posting "1" or "RETURN" in column X of the same row.
Please, let me know, if you have understood my query, or if you'd like me to specify it further :3
I'm looking forward to any help or advice that could follow!
Thank you very much in advance
Warm regards,
LitoII
This forum has poven to be very useful when I'm having real troubles with Excel, so I hope you guys will be able to give me a hand this one time once again! Thank you in advance
My issue consists of a database of routes A-B-C-D. But sometimes there is A-B-D-C (A and B stay the same, but C and D are reversed, which is actually the same route but in the return direction). I would like to be able to identify such cases as the data consists of 10k entries and it is pretty much unhuman to start identifying them one by one...
In detail:
I've got Origin, Destination and up to three Connecting Points. Each of the five points has four components (four columns per point) - code, name, country, region/continent. And then the database gives specific details for each route in the last three columns. All in all, columns A-T define the route and U, V and W give details about the route.
I want to be able to identify reversed Connecting Points when Origin and Destination stay the same. If CP1 and CP2 are the same as CP2 and CP1 of another entry, it could identify that entry by posting "1" or "RETURN" in column X of the same row.
Please, let me know, if you have understood my query, or if you'd like me to specify it further :3
I'm looking forward to any help or advice that could follow!
Thank you very much in advance
Warm regards,
LitoII