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)
W764 LibreOffice 220.127.116.11
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: 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