Thread: Read cells - Transposed in reverse order!

Can anyone give me a tip on how to read data from another sheet in transposed reverse order.
Sheet 2 shows what I am trying to achieve.

Thanks in advance

Chambo

Hi,

You could use a helper column B. Add '1' to B1 and '2' to B2. Drag B1:B2 down to create a numbered list 1-16.
Now Sort columns A1:B16 using col. B as the key in descending order.
Finally copy A1:A16 and Paste Transpose

Regards

Try this in "Sheet2" A1

=IF(COUNTA(Sheet1!$A:$A)+1-COLUMN(A$1)>0,INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A)+1-COLUMN(A$1),1),"")

Drag across until a blank cell is returned.

[EDIT]
Original formula was returning an extra value, now corrected.

Originally Posted by Marcol

Try this in "Sheet2" A1

=IF(COUNTA(Sheet1!$A:$A)+1-COLUMN(A$1)>0,INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A)+1-COLUMN(A$1),1),"")

Drag across until a blank cell is returned.

[EDIT]
Original formula was returning an extra value, now corrected.

Genius. Works perfect. Many thanks for the help

Happy to have helped ...