SOLVED - Sorting Rows

TERMINATOR32907 · Posted: Sat Mar 10, 2012 5:22 pm Post subject: SOLVED - Sorting Rows

Hello.
OK, here's what I have....basic spreadsheet used to keep track of scoring in a card league. We have over 100 members, and we score in multiple categories. Here's an abbreviated example:

What I need to be able to do if possible is SORT THE ROWS AND THEIR DATA IN DESCENDING ORDER.

Here's what happens when I try and sort the data in the first two rows, using the sort data feature:

As you can see, the first row is correct, it has listed the players with the highest scores in the correct order, callie, cops, birdie, etc. But the second row, with the actual point totals, remains unchanged. Its the same as before the sort.

What I need to come up with is this.....the two rows sorted with the player name and the correct point totals in the next row. Is this possible?

Thanks a lot

JohnV · Posted: Sat Mar 10, 2012 5:37 pm Post subject:

Select the rows to sort, do Data > Sort and click the Options tab. In the Direction section bullet Left to Right, above that uncheck Range has row labels. Click the Sort Criteria tab, bullet Descending and select to sort by Row 2.

TERMINATOR32907 · Posted: Sat Mar 10, 2012 6:31 pm Post subject:

Thanks for the reply, appreciate it.
But, thats exactly what I have been doing, and it still doesnt work. Do you think it might be because the results in the second row are based on formulas and not entered manually?
The reason I say this is because when I perform the same sort using the very last row (the one in green) it works fine. That row has the number of ladderbux won by the player, and it's entered manually.

Thanks

JohnV · Posted: Sun Mar 11, 2012 8:29 am Post subject:

Works for me when row 2 contains formulas. OOo3.3 under Windows.

Are you sure you are sorting by the Points row (whatever its number)?

TERMINATOR32907 · Posted: Sun Mar 11, 2012 4:04 pm Post subject:

Yes, I'm sure.

OK, here's what I tried....I copied the entire block of information, then went down to an open area and did a "paste special", telling the program to just paste text, numbers, and formats. No formulas. Here's what I have:

NOW, when I try the sort data in descending order, i get this!

It works! It has to have something to do with the fact that the row I'm trying to use to sort by first contains formulas which reference other cells, because as you can see when the forumlas are removed the sort works fine.

Any ideas?

Thanks

mgroenescheij · Posted: Sun Mar 11, 2012 9:56 pm Post subject:

Hi,