Sam

The formula I gave would return the rows starting from the end and working
backward
I pasted the formula in cell N2 of my Sheet and returned Row15 of your data
going downward.
I did say to switch to COUNT, if your data was all numeric apart from a
header, as opposed to Text data in Column C as posted in your example.

No matter, the solution you came up with is essentially the same, and I am
glad it resolved your problem.
--
Regards
Roger Govier

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

Thank you very much for reply and assistance.

I tried your formula but it didn't give me the required results. The first
row it returned was the third from the top of my named range "Data". I
think
because of the COUNTA($C:$C). Also, the rows of data should be returned
from
the bottom of the named range.

However, I played about with your formula and came up with this (fill
across
and down):

=INDEX(Data,ROWS(Data)-ROW(1:1)+1,COLUMN(A1))

It returns the rows of data in reverse order as required.

Thanks again for giving me something to work with.

Cheers,
Sam

Roger Govier wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200802/1