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..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add/Subtract columns from tab to tab in same file 3
Retrieve Column Header for Specific Data in a Row 3
Inventory Management? 1
Determining Changes between two Inventory Lists 5
KEEPING COUNT 6
Help needed, setting up conditions 4
Comparing two columns and returning value from another column 1
Subtotals in Pivot Tables 3

Back
Top