Average formula
 

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.

Average formula
 

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.

Average formula
 

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

"Gary''s Student" wrote:

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.

Average formula
 

If your values are in row #1, click on cell A2 and type the equation.
--
Gary''s Student - gsnu200778


"wannabe68" wrote:

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

"Gary''s Student" wrote:

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.

Average formula
 

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.

"Gary''s Student" wrote:

If your values are in row #1, click on cell A2 and type the equation.
--
Gary''s Student - gsnu200778


"wannabe68" wrote:

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

"Gary''s Student" wrote:

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.