Dave T
05-07-2013, 10:23 PM
Hello All,
This probably quite simple but is giving me grief…
I have around 700 rows with route nodes that detail a specific section of road.
For example node 001 may be the South Australian border and node 02C may be Bordertown and this is used with a program as 00102C.
Correspondingly there is a reverse leg of that route shown as 02C001 from Bordertown (node 02C) to the SA border (node 001).
In another column alongside each route there is a text description of the route that goes from the start to the end. For example route 00102C will have a description from the state border to Bordertown and 02C001 will have the same description but reversed according to direction of travel.
Is there a formula or something that in another column would reverse only the second occurrence of the number so that in a third column there will be 00102C and another duplicate of 00102C (02C001 reversed). That would mean I can filter on a route number and there should only be two results returned, making it easier to check that the text details of the route for the second route is a copy of the first route but has been reversed correctly.
If it helps I have the first three digits of the start node of the route identifiers in column A and the last three digits of the node identifiers for the end of the route in column B. In column C I have concatenated columns A and B to make a six digit route leg.
If each 'pair' of routes can be uniquely identified then the AutoFilter in my example should return only 00102C and 02C001 (the forward and return legs of the route).
I hope all of this makes sense…
Regards,
Dave T
This probably quite simple but is giving me grief…
I have around 700 rows with route nodes that detail a specific section of road.
For example node 001 may be the South Australian border and node 02C may be Bordertown and this is used with a program as 00102C.
Correspondingly there is a reverse leg of that route shown as 02C001 from Bordertown (node 02C) to the SA border (node 001).
In another column alongside each route there is a text description of the route that goes from the start to the end. For example route 00102C will have a description from the state border to Bordertown and 02C001 will have the same description but reversed according to direction of travel.
Is there a formula or something that in another column would reverse only the second occurrence of the number so that in a third column there will be 00102C and another duplicate of 00102C (02C001 reversed). That would mean I can filter on a route number and there should only be two results returned, making it easier to check that the text details of the route for the second route is a copy of the first route but has been reversed correctly.
If it helps I have the first three digits of the start node of the route identifiers in column A and the last three digits of the node identifiers for the end of the route in column B. In column C I have concatenated columns A and B to make a six digit route leg.
If each 'pair' of routes can be uniquely identified then the AutoFilter in my example should return only 00102C and 02C001 (the forward and return legs of the route).
I hope all of this makes sense…
Regards,
Dave T