Oh Wise Ones,

The below array formula finds the average of the last 5
values in a column. How do I modify it to display the last
5 values of the column?

=AVERAGE(A65535:INDEX(A1:A65535,LARGE(ROW(1:65535) *
(A1:A65535<""),5)))

Thanks,
Mike