paulfitz320
Board Regular
- Joined
- Jan 6, 2007
- Messages
- 122
- Office Version
- 365
- Platform
- Windows
Hi, I have 3 columns... EVENT-SCORE-AVG of Top 4
I need a formula for COL C that will put the average of the TOP 4 ranked (COL B) for each EVENT in COL A
Thanks
Event Score Avg Of Top 4
1 131 129.00
1 129 129.00
1 129 129.00
1 127 129.00
1 126 129.00
1 124 129.00
1 124 129.00
1 123 129.00
1 0 129.00
2 116 101.50
2 100 101.50
2 98 101.50
2 92 101.50
2 91 101.50
2 81 101.50
2 78 101.50
2 0 101.50
2 0 101.50
3 107 53.00
3 105 53.00
3 0 53.00
3 0 53.00
3 0 53.00
3 0 53.00
4 104 79.25
4 80 79.25
4 78 79.25
4 55 79.25
4 0 79.25
4 0 79.25
4 0 79.25
5 136 125.00
5 128 125.00
5 124 125.00
5 112 125.00
5 0 125.00
5 0 125.00
5 0 125.00
I need a formula for COL C that will put the average of the TOP 4 ranked (COL B) for each EVENT in COL A
Thanks
Event Score Avg Of Top 4
1 131 129.00
1 129 129.00
1 129 129.00
1 127 129.00
1 126 129.00
1 124 129.00
1 124 129.00
1 123 129.00
1 0 129.00
2 116 101.50
2 100 101.50
2 98 101.50
2 92 101.50
2 91 101.50
2 81 101.50
2 78 101.50
2 0 101.50
2 0 101.50
3 107 53.00
3 105 53.00
3 0 53.00
3 0 53.00
3 0 53.00
3 0 53.00
4 104 79.25
4 80 79.25
4 78 79.25
4 55 79.25
4 0 79.25
4 0 79.25
4 0 79.25
5 136 125.00
5 128 125.00
5 124 125.00
5 112 125.00
5 0 125.00
5 0 125.00
5 0 125.00