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