| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group by
I have a column of dates and a column of durations. I have used a pivot
table to work out the average duration by month. However, I also need to calculate the average after excluding the highest durations for each month. I have tried PERCENTRANK which works OK for the whole column but I can't figure out how to group it by month. I also don't want to have to have a column for each month using lookup or match. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
| How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
| Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Threaded Mode
