[libreoffice-users] data order

hi. I am preparing a calc file with 2 sheets; one with the results of matches and a first league 
table in alphabetical order; the second with the same  league table, but ordered by points, ranks. 
If I order the 'total points' column, it orders just thi colums, leaving the others unchanged 
(giving the points to the wrong team - bug?). then should i build a long list of complex nestled 
'if' functions for each cell (trying, but gives more errors); using 'max' function it selects just 
the higher one value (but without possibility of excluding higher values or so -  could it be 
modified ?)   ....  suggestions ?

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted