I have to columns full of data one column is "inventory" and the secon
column is "charged items" inventory is what should be on the shel
according to the computer, and charged items are the books that ar
checked out. So the inventory - charged items would more less give m
what "should" be on the shelf according to the computer.

So I want column C to list me everything that is in Column A that i
not in Column B.

Column A is Inventory Column B is charged items (goes up to 6000).
After I typed it out it seems very simply I just haven't figured ou
how to do it..

--
dsc5
-----------------------------------------------------------------------
dsc55's Profile: http://www.excelforum.com/member.php...fo&userid=1679
View this thread: http://www.excelforum.com/showthread.php?threadid=31988

Hi
as a starting point:
http://www.cpearson.com/excel/duplic...#InOneNotOther

--
Regards
Frank Kabel
Frankfurt, Germany

"dsc55" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
>
> I have to columns full of data one column is "inventory" and the
second
> column is "charged items" inventory is what should be on the shelf
> according to the computer, and charged items are the books that are
> checked out. So the inventory - charged items would more less give
me
> what "should" be on the shelf according to the computer.
>
> So I want column C to list me everything that is in Column A that is
> not in Column B.
>
> Column A is Inventory Column B is charged items (goes up to 6000).
> After I typed it out it seems very simply I just haven't figured out
> how to do it...
>
>
> --
> dsc55
> ---------------------------------------------------------------------
---
> dsc55's Profile:
http://www.excelforum.com/member.php...o&userid=16791
> View this thread:
http://www.excelforum.com/showthread...hreadid=319887
>