Creating A Named Range

Originally Posted by FDibbins

I would 1st ask why you have a need to give alternate rows a range name? If you are trying to add data on alternate rows, if the row headings have a similar wording, you may be able to use something like SUMIF()

Probably easier if I show you.
Sample Running Scores .xlsx

So Column C,F,I,L,O all show scores achieved in a Junior National League over 5 separate rounds.

Each row in these columns records two scores for each person, the score they shot and their handicap score.

Column S shows the sum of the three highest handicap scores that each person has achieved across all 5 rounds.

Column V however I want to find the highest score shot across all 5 rounds and to also display the persons name.

So the named range is there simply to not include the handicap scores (which are always considerably higher than the actual scores) when finding the highest score and then again to find the persons name.