In column L I wish to display the highest number in each group at the top of the group. Someone made me a macro (see attached) that worked in my sample sheet but when I put it into practice (see attached workbook) it comes up with an error. Just to let me know what I mean. I would want L1 to equal 5. L9=7, etc........ I have no idea why the code worked in the sample but not in mine. The code is in the workbook. Please do help.
Bookmarks