Say we have numbers in row #1,
=AVERAGE(1:1)
will get you the average.

AVERAGE does not need to know where the data starts and stopr, it ignores
blanks.

To reverse the data in a row, in A2 enter:

=IF(INDEX(1:1,1,257-COLUMN())="","",INDEX(1:1,1,257-COLUMN()))
and copy across. This formula will reverse all the cells in row 1, whether
they are numbers, words, or blanks.
--
Gary''s Student - gsnu200778


"wannabe68" wrote:

Could appreciate some help.
I have 18 rows of numbers. There are varying numbers in each row. First I
need the formula to average each row.
Secondly, how do I reverse the numbers in each row.
Example
4,9,2,5,7
how do I reverse the row to show, 7,5,2,9,4
Any help would be appreciated, been up all night to figure out how to do it.