Re: [libreoffice-users] VLOOKUP Problem

      If you look at my address above, you will see that I use Gmail. 
My email client is Thunderbird which has choices as to how to reply: 
Reply to List (possibly because the mail headers contain a "reply to"), 
Reply or Reply to all (when there does not seem to be a "reply to" in 
the mail headers). It uses IMAP and POP. (I have recently learned how to 
use the former.)
     The point is: there are email clients other than Thunderbird that 
give you the ability to reply to a list.

--Dan


On 02/02/2013 12:12 PM, Johnny Rosenberg wrote:
> 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