Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The first 25 percent
I have a multi-row, multi column spreadsheet. Of the columns, 3 of them are
the most crucial. Let's say, Column A is: User Column B is: Date Column C is: Cycle Time (Calculated from B and another column) What I would like to know is the average (median, etc...) Cycle Time for the FIRST 25% (50%, 75% etc...) of the Users signed up. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The first 25 percent
If by "first 25" you literally mean the first 25% of the entries (or if you
meant by date, you could do a sort) a formula to use might be: =AVERAGE(OFFSET($C$2,,,INT(0.25*COUNTA(A$2:A$100)) )) Change the 0.25 to 0.5, 0.75, or 1 to calculate the other percentages. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rum" wrote: I have a multi-row, multi column spreadsheet. Of the columns, 3 of them are the most crucial. Let's say, Column A is: User Column B is: Date Column C is: Cycle Time (Calculated from B and another column) What I would like to know is the average (median, etc...) Cycle Time for the FIRST 25% (50%, 75% etc...) of the Users signed up. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The first 25 percent | Excel Worksheet Functions | |||
Using Percent | New Users to Excel | |||
Percent | New Users to Excel | |||
Percent of | Excel Discussion (Misc queries) | |||
Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) |