Average formula

[wannabe68]

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.

 

[Gary''s Student]

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.

 

[wannabe68]

Sorry Gary, I am just starting out with Excel.
Where do I type
=AVERAGE(1:1)

 

[Gary''s Student]

If your values are in row #1, click on cell A2 and type the equation.

 

[wannabe68]

Got the average OK.
Now trying to sort numbers from left to right, ie reverse the seqence of
numbers in a row. At one time I figured it out by can't remember it. I sort
of remember that I highlighted the worksheet, then from the tool bar, (File,
Edit, View, Insert, format, sort, etc) there was a command, without a
formula, to reverse items in a row. Any help would let me get some sleep
tonight.