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