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 <[email protected]>wrote: > 2013/2/2 John Meyer <[email protected]>: > > 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: [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
