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

Hi Sudheer,

Excel Help for Hi Sudheer, in Excel Real Options Valuation Template


Forum TopicLogin

Hi Sudheer,

Rate this:
(4/5 from 2 votes)
ConfusedCould 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
 
View Full Post

Find relevant Excel templates and add-ins for Hi Sudheer, in the

© Business Spreadsheets   Legal   Follow us: