Thread: Average formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wannabe68 wannabe68 is offline
external usenet poster
 
Posts: 20
Default 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.