| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inverting sign | Excel Discussion (Misc queries) | |||
| inverting data for a graph | Excel Worksheet Functions | |||
| inverting the y axis | Charts and Charting in Excel | |||
| Inverting a data column | New Users to Excel | |||
| inverting a column of data | Excel Discussion (Misc queries) | |||
Hybrid Mode
