Trying to lock an entire row together for sorting.

I'm sure this is an easy thing to do. What I have is a sheet where I record results from a race. It calculates the lowest 4 out of 5 scores for the event. Now comes the fun part. The participants name is in a merged cell beside the data,and what I need to be able to do is sort the results from lowest score to highest score and have their name move with the sorting.

Each sheet is for a separate class, so it does not need to sort between sheets.

That sounds right in my head, lol.

TIA

Agree with TMS. Is there are good reason why you need the merged cells?

ok, so if all the cells are the same size, I still can't get the sheet to move the names with rest of the row.

So peter in row 1, paul in row 2 and mary in row 3 need to move with the results and sorting. I am high lighting the total row and selecting sort,then selecting lowest to highest and that all moves, but the names stay where they are.

Ok, book with data in it. The last column needs to be sorted from lowest number to highest number and keep the name of the person who has that score. The person with the lowest score is thew winner of the event.

You need to select ALL columns that you wish to sort, i.e. Columns A:I. Then sort by the Total column Smallest to Largest.

One issue you will have is with the 0's in the Total column being sorted as the lowest values, so you'll need to make the Total formulas equal to a blank "" if no scores have been added to that row.
Easiest way to do this is to leave the score cells blank rather than add a zero, then wrap your Total formula in an IFERROR function to equal "".

So...

=IFERROR(SUM(SMALL(D2:H2,{1,2,3,4})),"")