Home > Forum Home > Excel Real Options Valuation Template > Need help in reversing the numbers in a column in Excel Share

Need help in reversing the numbers in a column in Excel

Excel Help for Need Help In Reversing The Numbers In A Column In Excel in Excel Real Options Valuation Template


Forum TopicPost Reply Login

Need Help In Reversing The Numbers In A Column In Excel

Rate this:
(3/5 from 1 vote)
ConfusedHi,
I want to reverse the a column irrespective of the data linked to it.For example,I have numbers in as below:
column A
----
12
01
45
23
90
76
-----
But I want the numbers to be reversed irrespective of the other columns.Can you please help me out with a solution on how to reverse the numbers in column A.(I repeat the order of the numbers should not be changed.My column A should like as mentioned below)
Column A
----
76
90
23
45
01
12
----
Thank You.
Regards,
Sudheer.
 Sudheer
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
You could create a simple order in another column 1,2,3, etc then sort on this column to reverse the numbers.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Could this be what you are looking for?... 

Excel Spreadsheet:
 ABCDEF
1

 

Column Name

 Row Number

 

Result 

 

2

12

A

 7

=ROW(A7)

 76

=INDIRECT(B2&C2) 

3

01

A

 6

=C2-1 

 90

=INDIRECT(B2&C2)

4

45

A

 5

=C3-1

 23

=INDIRECT(B2&C2)

5

23

A

 4

=C4-1

 45

=INDIRECT(B2&C2)

6

90

A

 3

=C5-1

 01

=INDIRECT(B2&C2)

7

76

A

 2

=C6-1

 12

=INDIRECT(B2&C2)


Hope it helps...
 Ugur Senan
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Need help in reversing the numbers in a column in Excel in the