Re: [libreoffice-users] calc filter?

> Hi,
> My understanding is you want to re-display the list in the order you provided.

Set B2 to B17 to your list
 Then set A2 to A17 to your required order. Note in column A you are telling the numbers in column 
B where they should appear in the sorted list i.e Number 16 (sixteen) in column B should end up as 
number 2 in the sorted list.
Select A2 to A17 and do a sort. 
When asked if you want to extend the sort click "Extend"   

    A2 to A17                    B2 to B17 before sort           B2 to B17 after sort               
Your required order

                                                        

Hope this makes sense

Tony Bray
tonybsa@mac.me
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4







-- 
To unsubscribe e-mail to: users+unsubscribe@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