Hypersonique or Anyone/EXCELPrev TopicNext Topic

• Sandy K

  

  Clarkston, Michigan
  United States
  Member #76
  January 6, 2002
  8,528 Posts
  Offline
  Dec 4, 2004, 10:41 am

  ▲▼

  I had this formula once but when my hard drive went kapoot...I lost it......

  I want to do some research for the next 3 weeks or so and I need a couple formulas......................I would appreciate any help.

  I need the formula for the Median of a number.

  I am doing it on root sums.......I have them in 9 columns..............1-9

  I want to go to the root sum 1 (example cell A)....................and rows 1:2000.................could you tell methe formula of how to get the median of root sum of 1?

  Also: how would I get the AVERAGE OF THE ROOT SUM OF 1?  THE FORMULA.

  And the harder one: What formula can I use to get the SKIP AVERAGE for the Root sum of 1 in that column?

  3 basic formulas but I am not a programmer so I don't know how complicated the formula would be.  I really would appreciate the help.

  Hyper, by the way, have a great Christmas holiday................

  Sandy