Welcome Guest
Log In | Register )
You last visited December 5, 2016, 3:33 pm
All times shown are
Eastern Time (GMT-5:00)

Hypersonique or Anyone/EXCEL

Topic closed. Posted 12 years ago. No replies.

Page 1 of 1
PrintE-mailLink
Sandy K's avatar - graphic pub.jpg
Clarkston, Michigan
United States
Member #76
January 6, 2002
8528 Posts
Offline
Posted: December 4, 2004, 10:41 am - IP Logged

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