Need to print the reverse of the range

[vshukla]

I have attached the sample file where there is a range in question and desired out is also shown.
I need to it using excel function.

Thanks in advance

[Olly]

Something like:

Please Login or Register  to view this content.

[vshukla]

thanks, it really works.
Can you please help me to understand the formula that what does the below part solve the purpose in the formula.....

ROW()+2)

Row() gives the row number of the current selected cell but in this formula how it is giving the value and which row is selected?

I am not getting it.

[Olly]

In row 2 we want the last cell of the range - so the count of nonblank cells - 0 (row number -2)
In row 3, we want to index the count of nonblank cells - 1 (row number - 2)
In row 3, we want to index the count of nonblank cells - 2 (row number - 2)

Follow?