2013/2/2 John Meyer <john.l.meyer@gmail.com>:
BTW, this is off topic, but is there any way to configure GMail so when
I
hit reply I reply to the list and not to the person?
The new behaviour of this list sucks badly for us gmail users. In most
cases I accidently relies to the person rather than to the list, sorry
for that.
The answer seems to be to click Reply to all, remove the single
person's address and then move the list address from CC: to TO: (just
click and drag it).
As I said, I forget that all the time…
Johnny Rosenberg
On Sat, Feb 2, 2013 at 9:57 AM, John Meyer <john.l.meyer@gmail.com>
wrote:
I'll try it out. Personally I don't know why I'm a neat freak in terms
of
not wanting blanks, but that's just me.
On Sat, Feb 2, 2013 at 9:54 AM, Brian Barker
<b.m.barker@btinternet.com>wrote:
At 08:31 02/02/2013 -0700, John Meyer wrote:
I have two columns. Column A displays the logon names being used and
Column B contains all possible logons (technically it's on another
sheet,
but I'll simplify). What I want to appear on column C is a list of
all
logons that are not being used.
Here's an addition to my previous attempt. In column D, you could put
=C$1, =C$2, =C$3, and so on. (It's no good trying to fill these down
the
column, as you will get either =C1, =C2, etc. or =C$1 all the way. I
don't
see any way to fill what you actually need other than manually - and
unreliably!)
Now you can sort column D each time you want to consolidate your list.
Note that the formulae in column D will themselves be sorted (so that
=C$1
is no longer necessarily in D1 and so on), but this will not upset the
scheme and does not need to be reset before your next update. All
that is
necessary is that you have an exactly complete set of the formulae in
the
range of column D - in whatever order.
Is that any better?
Brian Barker
--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.**
org <users%2Bhelp@global.libreoffice.org>
Problems?
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive:
http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot be
deleted
--
For unsubscribe instructions e-mail to:
users+help@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
--
For unsubscribe instructions e-mail to: users+help@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