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?
On Sat, Feb 2, 2013 at 9:57 AM, John Meyer <[email protected]> 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 <[email protected]>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: [email protected].** >> org <users%[email protected]> >> 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: [email protected] 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
