Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


Hi,
My understanding is you want to re-display the list in the order you
provided. If you can calculate the odd indices (the even numbered ones
are always equal to the number of elements minus the odd index plus 1
in your list), replace the number in the sequence by that calculation.
Otherwise, you can place the index directly in the formula. To show the
list in the order you specified, you can use the following, in a
location of your choice, one line per row:
=indirect(address(row($b$2)+1-1;column($b$2)))
=indirect(address(row($b$2)+16-1;column($b$2)))
=indirect(address(row($b$2)+8-1;column($b$2)))
=indirect(address(row($b$2)+9-1;column($b$2)))
=indirect(address(row($b$2)+4-1;column($b$2)))
=indirect(address(row($b$
2)+13-1;column($b$2)))
=indirect(address(row($b$2)+5-1;column($b$2)))
=in
direct(address(row($b$2)+12-1;column($b$2)))
=indirect(address(row($b$2)
+2-1;column($b$2)))
=indirect(address(row($b$2)+15-1;column($b$2)))
=indi
rect(address(row($b$2)+7-1;column($b$2)))
=indirect(address(row($b$2)+10
-1;column($b$2)))
=indirect(address(row($b$2)+3-1;column($b$2)))
=indirec
t(address(row($b$2)+14-1;column($b$2)))
=indirect(address(row($b$2)+6
-1;column($b$2)))
=indirect(address(row($b$2)+11-1;column($b$2)))
If your data is displayed on another page, then you can use the page name in the ADDRESS function.
I hope this helps.
Regards,
Rémy Gauthier.

Le lundi 29 février 2016 à 15:01 -0600, Beau Thompson a écrit :
HI all,
im working on a calc sheet  where i have a list of 16 names 1 to 16
B2 
TO B17
I lie to filter the list in this order
1
16
8
9
4
13
5
12
2
15
7
10
3
14
6
11

thanks beau

-- 
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.