Hi Sam
Try
=INDEX(Data,COUNTA($C:$C)-(ROW(A1)-1),COLUMN(A1))

I used COUNTA on your sample, if the data is numeric you could also use
COUNT
COUNT would ignore any text in row 1
Copy the formula across through 7 columns to get your 8 values, then copy
all 8 formulae down through a further 5 rows

--
Regards
Roger Govier

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:7fec9e979c3f0@uwe...
Hi All,

I have an 8 column by many rows, dynamic named range called "Data". The
named
range starts in row 2, column "C". The oldest data is at the top, row 2
and
the most recent data is at the bottom of the named range. "Data" holds
numeric values.

Scenario:
I would like a formula using the named range, "Data", to return the most
recent, last 10 rows from the bottom of the named range in reverse row
order.

Sample Data Layout: Rows 6-15 inclusive cover the last 10 rows.

Row1 111 114 116 125
Row2 118 112 117 123
Row3 116 110 114 125
Row4 118 110 116 117
Row5 116 120 129 131
Row6 112 119 128 131
Row7 112 119 122 123
Row8 112 118 116 121
Row9 112 119 113 118
Row10 115 118 121 138
Row11 113 121 123 125
Row12 113 119 124 125
Row13 112 115 119 128
Row14 118 119 121 130
Row15 112 114 121 125

Expected Results:
Return last 10 rows, rows 6-15 in reverse row order. Last row, row15
should
be returned 1st.

Row15 112 114 121 125
Row14 118 119 121 130
Row13 112 115 119 128
Row12 113 119 124 125
Row11 113 121 123 125
Row10 115 118 121 138
Row9 112 119 113 118
Row8 112 118 116 121
Row7 112 119 122 123
Row6 112 119 128 131

Thanks
Sam

--
Message posted via http://www.officekb.com