Hello and thanks to Alan & Brian (who replied private) Yes my choice of words to describe the problem wasn't great, 'sort' was the first thing I tried so was probably the first to swim up from the murk.
The mock sheet shows a problem from a larger sheet saved as a .xls, stored within Dropbox and accessed and added to by other people - all of whom have limited spreadsheet knowledge. Anything I add to the sheet has to add minimum chance of giving a user the possibility of screwing things up. Which was why I was keen to present the member type emails in separate columns to just be used. So the first thing I tried was 'Auto filter', that worked but the user still had to select the relevant from up to 60 rows (not a big problem I suppose). However if a user sorted the sheet and subsequently saved the sheet then the next user would be presented with a sheet they hadn't seen before, do a bit of a panic and possibly try to add data in the wrong place. I understand filters, they 'might' but best not to wear rose tinted glasses. I also tried 'If' statements. Consternation (include a 'index column + member type = unique) and VLOOKUP. Neither of which gave good result. I was trying to set something up that wouldn't mean extra and ongoing work for me, but maybe just maintaining a simple text file is a way to go. Possibly this whole 'member details' sheet would now be better served by a database. But I'm not great at database stuff and I don't know what my users would make of it. If you have any other solutions/thoughts I'd be grateful (theres shed loads of spreadsheet stuff (I know) I don't know) ----- IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-sort-in-to-columns-tp4098035p4098086.html Sent from the Users mailing list archive at Nabble.com. -- 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
