[libreoffice-users] Re: Calc - sort in to columns

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