| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate average pay from highest five consecutive years
I have a workbook with two worksheets
Worksheet #1 has the following: Employee# Year Amount 12345 2002 40000 12345 2001 26390 12345 2000 33184 12345 1999 38861 12345 1998 25198 12345 1997 32015 98765 2002 67923 <etc etc etc etc Worksheet #2 has a cell that I need to put the average of the five highest years of pay for each employee record. Any ideas how to write this function? Thanks in advance. Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highest total of any three consecutive numbers in a range. | Excel Worksheet Functions | |||
| How do I average a row of 13 enries using the 8 highest in value. | Excel Discussion (Misc queries) | |||
| Highest 3 in 10 Consecutive Numbers | Excel Worksheet Functions | |||
| Highest 3 in 10 Based on Consecutive Cells | Excel Discussion (Misc queries) | |||
| Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
Threaded Mode
