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+unsubscr...@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
