|
Inverting a set of data
Hi, I'm going through a large data base and need to invert the data so the
reverse route is shown. A B A B e.g. 1 2 6 5 3 4 4 3 5 6 to 2 1 Is there a quick way of doing this either through a formula or function that anybody knows? Any help would be greatly appreciated. |
Inverting a set of data
Maybe sort both columns in descending order and move column A after column B!
Regards, Stefi €žsimac€ť ezt Ă*rta: Hi, I'm going through a large data base and need to invert the data so the reverse route is shown. A B A B e.g. 1 2 6 5 3 4 4 3 5 6 to 2 1 Is there a quick way of doing this either through a formula or function that anybody knows? Any help would be greatly appreciated. |
Inverting a set of data
Sorry, my example was inapropriate.
The order in which column A & B are in can not be changed as these represent a point on a path: A B 4687 30033 30033 77258 77258 30686 30686 30034 30034 30035 30035 30449 30449 4689 To sort sort them using assending/decending order would also change this path. Basicly I need the path to run backwards starting at 4689 in cell A1. "Stefi" wrote: Maybe sort both columns in descending order and move column A after column B! Regards, Stefi €žsimac€ť ezt Ă*rta: Hi, I'm going through a large data base and need to invert the data so the reverse route is shown. A B A B e.g. 1 2 6 5 3 4 4 3 5 6 to 2 1 Is there a quick way of doing this either through a formula or function that anybody knows? Any help would be greatly appreciated. |
Inverting a set of data
In C1 enter =ROW(),
fill it down to the end of your table, copy column C and PasteSpecial/Values on itself, select range A1:Clastrow, DataSort by column C in descending order, select column A, right click on the right border, drag it after column B, choose shift to the right and move, delete column C. Stefi €žsimac€ť ezt Ă*rta: Sorry, my example was inapropriate. The order in which column A & B are in can not be changed as these represent a point on a path: A B 4687 30033 30033 77258 77258 30686 30686 30034 30034 30035 30035 30449 30449 4689 To sort sort them using assending/decending order would also change this path. Basicly I need the path to run backwards starting at 4689 in cell A1. "Stefi" wrote: Maybe sort both columns in descending order and move column A after column B! Regards, Stefi €žsimac€ť ezt Ă*rta: Hi, I'm going through a large data base and need to invert the data so the reverse route is shown. A B A B e.g. 1 2 6 5 3 4 4 3 5 6 to 2 1 Is there a quick way of doing this either through a formula or function that anybody knows? Any help would be greatly appreciated. |
Inverting a set of data
Cheers, worked a treat :)
"Stefi" wrote: In C1 enter =ROW(), fill it down to the end of your table, copy column C and PasteSpecial/Values on itself, select range A1:Clastrow, DataSort by column C in descending order, select column A, right click on the right border, drag it after column B, choose shift to the right and move, delete column C. Stefi €žsimac€ť ezt Ă*rta: Sorry, my example was inapropriate. The order in which column A & B are in can not be changed as these represent a point on a path: A B 4687 30033 30033 77258 77258 30686 30686 30034 30034 30035 30035 30449 30449 4689 To sort sort them using assending/decending order would also change this path. Basicly I need the path to run backwards starting at 4689 in cell A1. "Stefi" wrote: Maybe sort both columns in descending order and move column A after column B! Regards, Stefi €žsimac€ť ezt Ă*rta: Hi, I'm going through a large data base and need to invert the data so the reverse route is shown. A B A B e.g. 1 2 6 5 3 4 4 3 5 6 to 2 1 Is there a quick way of doing this either through a formula or function that anybody knows? Any help would be greatly appreciated. |
Inverting a set of data
You are welcome! Thanks for the feedback!
Stefi €žsimac€ť ezt Ă*rta: Cheers, worked a treat :) "Stefi" wrote: In C1 enter =ROW(), fill it down to the end of your table, copy column C and PasteSpecial/Values on itself, select range A1:Clastrow, DataSort by column C in descending order, select column A, right click on the right border, drag it after column B, choose shift to the right and move, delete column C. Stefi €žsimac€ť ezt Ă*rta: Sorry, my example was inapropriate. The order in which column A & B are in can not be changed as these represent a point on a path: A B 4687 30033 30033 77258 77258 30686 30686 30034 30034 30035 30035 30449 30449 4689 To sort sort them using assending/decending order would also change this path. Basicly I need the path to run backwards starting at 4689 in cell A1. "Stefi" wrote: Maybe sort both columns in descending order and move column A after column B! Regards, Stefi €žsimac€ť ezt Ă*rta: Hi, I'm going through a large data base and need to invert the data so the reverse route is shown. A B A B e.g. 1 2 6 5 3 4 4 3 5 6 to 2 1 Is there a quick way of doing this either through a formula or function that anybody knows? Any help would be greatly appreciated. |
| All times are GMT +1. The time now is 08:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com