Re: [libreoffice-users] calc filter?

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