At 12:23 02/02/2013 -0500, Keith Eonly wrote:
On Sat, 2 Feb 2013 08:31:35 -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. 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 as well. I've tried VLOOKUP and got sort of
an answer, but not quite the one. Any ideas?
In column C use
=IF(A1=B1,A1,"")
It tests for column A and B match, returns column A if true, and an
empty cell if false.
Unfortunately that suffers from two problems:
o It lists the names in use, not - as required - those not in use.
o (More important) It relies on the names in column A being
positioned against the relevant entry in column B. In the example
given, it would treat George as not in use and Jason as in use -
neither of which is correct. If the user was required to insert the
names in column A in the correct places for the scheme to work, he
would have done all the work already.
Brian Barker
--
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
