Mazzaropi

Senior Member

Location: Belo Horizonte, Brazil

Posts: 170

Quote:

Originally Posted by pallavi

Hi,
I have a set of 1000 values in a column 7 i want to find the avg of top 70% of population.
eg If the nos are like
1000, 400, 300, 10, 50, 30, 100, 200
so the top 70% of nos are 1000,400,300,100,200. & get the average.

Similarly the avg of bottom 70% of the population.

--------- HELP from Brazil ---------

Dear PALLAVI, Good Morning.

I did an example to you.
It´s attached.

Take a look and tell me if it worked for you.

Have a nice day.

Attached Files

17-APRIL-2012-ExcelBanter_Help_to_Pallavi_From_Brazil.zip (3.0 KB, 51 views)

__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding the Average	Mike H.	Excel Discussion (Misc queries)	4	March 3rd 08 05:41 PM
A formula to AVERAGE IF but only average a set number of values	[email protected]	Excel Worksheet Functions	2	January 31st 08 08:28 PM
I need help finding an average	JHL	Excel Discussion (Misc queries)	3	June 9th 07 07:59 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row	Sam via OfficeKB.com	Excel Worksheet Functions	13	July 31st 05 03:59 PM
Finding MIN, MAX, and average	jim hensen	Excel Programming	1	October 9th 04 06:38 PM

All times are GMT +1. The time now is 01:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us