[libreoffice-users] Re: Calc, selecting from a list ? vlookup maybe ?

IGraham wrote
> I want new lists based on the membership type
>
> Anyone know how i can do  this   

You can simply add a column title to each column (e.g. on B13 Type and C13
Name)
Click on B13 and then on menu Data, Filter, AutoFilter
Click on the down arrow that shows up to the right of Type, uncheck the
"All" box at the bottom of the filter dialog and choose one Type (e.g. C/M)
You can simply use this filter to see each type or you can copy the result
to another sheet or file
Notice that you can not copy to the columns (as in your example) to the
right because some lines are filtered.

Hope this helps.



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-selecting-from-a-list-vlookup-maybe-tp4144307p4144385.html
Sent from the Users mailing list archive at Nabble.com.

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