Re: [libreoffice-users] VLOOKUP Problem

I figured as much.  That shouldn't be a problem as long as I make sure it
fires on every update of column B.


On Sat, Feb 2, 2013 at 8:53 AM, Johnny Rosenberg <gurus.knugum@gmail.com>wrote:

> 2013/2/2 John Meyer <john.l.meyer@gmail.com>:
> > 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.  For instance:
> >
> > COLUMNA:
> >
> > Frank
> > Harry
> > George
> >
> > COLUMNB
> > Frank
> > Harry
> > Jason
> > George
> > Steven
> >
> >
> > So what I want to appear in column c is:
> >
> > Jason
> > Steven
> >
> >
> > I'd also like this to be dynamic, so as I pull logons and delete them,
> the
> > list updates asd well.  I've tried VLOOKUP and got sort of an answer, but
> > nor quite the one.  Any ideas?
>
> My guess is that this is impossible without involving a macro. The
> problem is that there is no cell function that looks for first
> non-match in a list and displays its row number. If there was such a
> cell function, this would have been an easy task.
> As I said, just a guess. Maybe someone will tell me that I'm wrong.
> That would be nice.
>
>
> Johnny Rosenberg

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