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

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
View this message in context:
Sent from the Users mailing list archive at

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.