Comparing two Columns

  • Thread starter Thread starter dsc55
  • Start date Start date
D

dsc55

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..
 
Back
Top