PC Review


Reply
Thread Tools Rate Thread

how can i view the range of 75% of a column

 
 
=?Utf-8?B?U3Vzem4=?=
Guest
Posts: n/a
 
      27th Feb 2006
I want to know the 75% majority range of values of a column, and what is the
25% below and above those values.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SXZv?=
Guest
Posts: n/a
 
      27th Feb 2006
try percentile or quartile function
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
AVERAGE a range in a column if another column's range equals a val bob$ Microsoft Excel Misc 3 24th Feb 2009 07:42 AM
How do I prevent a formula range from changing when Iinsert a column within said range? George Microsoft Excel Discussion 4 5th Mar 2007 06:46 PM
formula to sort a range so that it matches the exact rows of a column that is outside that range? steveo Microsoft Excel Misc 1 18th Jun 2006 02:05 AM
How to count dates within a certain range in a column with mutiple date range entries Krisjhn Microsoft Excel Worksheet Functions 2 1st Sep 2005 01:59 PM
Transfering VBA Array Column Range to Excel Column Range ExcelMonkey Microsoft Excel Programming 5 22nd Jan 2004 05:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:31 PM.