Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sample data:
Rank Minutes 1 34792 2 28301 3 26718 4 19282 5 16849 6 11002 ....1500 0 Basically I then request to view let's say the top 5...then I need a formula that will look for the top 5 minutes then determine what percentage that is of the whole. For example, in this case, let's say the sum of all 1500 entries is 592,000. And I say top 3..then in this case the formula would calculate 34792+28301+26718=89811/592,000 = 15% of total data. If I request top 5 then it would give me 34792+28301+26718+19282+16849=125582/592,000=21%. Any ideas on the formula? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Averaging | Excel Discussion (Misc queries) | |||
Excell vba getting error after searching 256 columns | Excel Discussion (Misc queries) | |||
Averaging a column with 0's | Excel Worksheet Functions | |||
Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
Averaging | Excel Discussion (Misc queries) |