Welcome to the MrExcel board!
Do you really need a macro? Could you use one of these formulas, copied down?
Highest Hours
| A | B | C | D | E |
1 | NUMBER | NAME | HOURS | HIGHEST HOURS | |
2 | 9999 | XXXX | 23 | 54 | 54 |
3 | 6577 | XXXX | 43 | 66 | 66 |
4 | 6577 | XXXX | 66 | 66 | 66 |
5 | 9999 | XXXX | 22 | 54 | 54 |
6 | 6577 | XXXX | 53 | 66 | 66 |
7 | 6577 | XXXX | 23 | 66 | 66 |
8 | 9999 | XXXX | 54 | 54 | 54 |
9 | 6577 | XXXX | 65 | 66 | 66 |
10 | 9999 | XXXX | 22 | 54 | 54 |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:75px;"><col style="width:57px;"><col style="width:65px;"><col style="width:127px;"><col style="width:43px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas |
Cell | Formula | D2 | =MAXIFS(C$2:C$10,A$2:A$10,A2) | E2 | =AGGREGATE(14,6,C$2:C$10/(A$2:A$10=A2),1) |
<tbody>
</tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4