Reverse order

[mmeier363]

Hey looking to see if there is a way to calculate a reverse order, I have to reverse 3k cells and want to know if there is just a way I can start with the top cell to be D1-->[=C3000] then D2-->[=C2999] then D3-->[=C2998]...and so on. I was thinking some type of offset function but cant seem to get the parameters set correctly. I cant do a revere sort as the cells in column C need to change. I feel that this should be easier than I am making it but cant figure it out. Thanks a lot

 

[Oaktree]

D1=INDEX(C$1:C$3000,3001-ROW(D1)) copied down.

 

[Joe4]

They entering this in D1 and copying down:

=INDIRECT("C" & 3001-ROW())

 

[mmeier363]

Thanks for the help this worked Great, I don't know why I did not think of using index this way.