Sort Issue (2000 sp3)

Topic

New Reply

Greetings!
It has been a little while since my last post. Here is my issue. I have a Soccer tracking spreadsheet that I am using for a 4v4 Tourney. Basically, when I select the cells to sort based upon a certain column the first row does not sort to the proper spot.

I select Cells B20 thru I27, Tab to I20 then sort in descending order. Row 20 data will not sort down to the proper order.

Any Ideas?

thanks,
Brad

Reply | Quote

Replies

Hi Brad

Make sure you select the “No header row” option at the bottom of the sort dialog box.

Reply | Quote

Thanks,
However, I am not using the sort dialog box. I am using the quick sort button which does not give me an option.

Brad

Reply | Quote

In that case select the range B19 to I27 instead.

Reply | Quote

Thanks to all!

Works like I expect
Brad

Reply | Quote

Make sure “No Header row” is chosen in the dialog.

Steve

Reply | Quote