Hi Larry and all: At first you have to copy the headers of your table at you side of you table for example or at the end if it isn't big.
Then you have to add the filter that you need and put bellow of the header that you want to filter. Then run the wizard : Advanced Filter (Before select the table that you want to filter) and in options you can select where to put the datas filtereds. Example: Table Province Sells Costs Profits Alajuela 10 2 8 Puntarenas 20 1 19 Limón 20 4 16 Heredia 10 7 3 San José 20 5 15 Alajuela 10 8 2 Heredia 40 9 31 Puntarenas 50 12 38 Advanced Filter:(Read Filter Criteria From) Province Sells Costs Profits > 20 Results of Advance data Filtereds: Province Sells Costs Profits Heredia 40 9 31 Puntarenas 50 12 38 In this case, we filtered the column Sells to show only Province that have sells higher than 20 I hope this help, Jorge Rodríguez El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: > I selected Data>Filter>Advanced Filter; however, > I had no idea what to do next. I selected Help button, > which sent my browser to: > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113 > > which was, again, no help. > > How do I fill out the "Advanced Filter" dialog? > > -regards, > Larry > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: [email protected] 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
