2013 Archives by date, by thread · List index

# Re: [libreoffice-users] VLOOKUP Problem

```Okay.  I guess I can do that, even though I'd like a reply to list option
(maybe an idea for a google lab, eh)

On Sat, Feb 2, 2013 at 11:28 AM, Tom Davies <tomdavies04@yahoo.co.uk> wrote:

```
```Hi :)
the different names, just leave 1 or 2 or so in the "To" field and then you
don't need to copy&paste from the CC.  It is a pain but the delete key is
quite useful when you get too many copies of the same email.
Regards from
Tom :)

```
```________________________________
From: Kieran Peckett <crazyskeggy@gmail.com>
To: Johnny Rosenberg <gurus.knugum@gmail.com>
Cc: LibreOffice Användare <users@global.libreoffice.org>
Sent: Saturday, 2 February 2013, 17:45
Subject: 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
```
```

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