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


At 07:37 24/03/2015 -0700, Graham Lovatt wrote:
If i have a list over a number of columns how would i create a new list of only certain rows from that list

If you want to do this dynamically, so that the sub-list updates automatically from the main list (as is suggested by your mentioning the VLOOKUP() function), the problem is complicated, I think. But if you are prepared to extract the sub-list manually, so that you would need to repeat the process each time you needed an updated sub-list from a modified main list, you can do this fairly easily using the Sort facility.

Yes i know that's as clear as mud so i've attached a example spreadsheet. The column starting at B14 has membership type with (C14) a name next to it - the actual sheet has more data. Each row below has different membership type and associated data. I want new lists based on the membership type. The main list may be sorted changing the order of the rows.

o Select all the main list range: all the relevant columns and rows.
o Go to Data | Sort... .
o On the Options tab, tick "Range contains column labels" or not - as appropriate.
o On the Sort Criteria tab, for "Sort by", select your membership type column.
o OK.
o Now select each sub-list range in turn and copy and paste the rows to form your new lists.

Since you say the order of entries in the original list does not need to be fixed, it would be possible to omit the final copying stage and use the sorted material in place. This would simplify what you need to do as the original list is edited: you would need just to repeat the sort, without the subsequent copying.

I trust this helps.

Brian Barker


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