Re: [libreoffice-users] VLOOKUP Problem

John: there is a lab (i forget its name) that puts reply to all the first
option in the reply box, and on the top-right of the message


On 2 February 2013 17:12, Johnny Rosenberg <gurus.knugum@gmail.com> 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

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