[libreoffice-users] Re: Generate Unique List from Values in Column
Joel, Am 08.10.2013 19:43, schrieb Joel Madero: Suggestions appreciated as always Do you *have* to use LibreOffice for that? (I find it sometimes quicker to just export the data list into a text file and do a sort -u on it) Nino -- 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
[libreoffice-users] Re: Generate Unique List from Values in Column
Joel, Am 08.10.2013 19:43, schrieb Joel Madero: Suggestions appreciated as always Do you *have* to use LibreOffice for that? (I find it sometimes quicker to just export the data list into a text file and do a sort -u on it) Nino -- 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
Re: [libreoffice-users] Re: Generate Unique List from Values in Column
On 10/09/2013 04:18 AM, Nino wrote: Joel, Am 08.10.2013 19:43, schrieb Joel Madero: Suggestions appreciated as always Do you *have* to use LibreOffice for that? (I find it sometimes quicker to just export the data list into a text file and do a sort -u on it) Nino Yeah I did have to, there was a formula dependent on it, adding additional export steps wasn't necessary, Brian figured out the problem, regular expressions needed to be turned off as the brackets in my data were causing issues. Best, Joel -- 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
[libreoffice-users] Re: Generate Unique List from Values in Column
Hi Joel, if you do not want to use formulas, there are at least three options to do it in a simple way. 1) Menu/Data/Pivot Table http://nabble.documentfoundation.org/file/n4077276/Captura.png 1) Menu/Data/Consolidate http://nabble.documentfoundation.org/file/n4077276/Captura.png 2) Menu/Data/Filter/Standar filter | Advanced filter http://nabble.documentfoundation.org/file/n4077276/Captura2.png Regards. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Generate-Unique-List-from-Values-in-Column-tp4077250p4077276.html Sent from the Users mailing list archive at Nabble.com. -- 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
Re: [libreoffice-users] Re: Generate Unique List from Values in Column
On 10/08/2013 01:33 PM, mariosv wrote: Hi Joel, if you do not want to use formulas, there are at least three options to do it in a simple way. 1) Menu/Data/Pivot Table http://nabble.documentfoundation.org/file/n4077276/Captura.png 1) Menu/Data/Consolidate http://nabble.documentfoundation.org/file/n4077276/Captura.png 2) Menu/Data/Filter/Standar filter | Advanced filter http://nabble.documentfoundation.org/file/n4077276/Captura2.png Regards. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Generate-Unique-List-from-Values-in-Column-tp4077250p4077276.html Sent from the Users mailing list archive at Nabble.com. None of these will work, I need a formulas as it's part of a bigger project analyzing my finances. Thanks though for the suggestion. Best, Joel -- 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