Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Finding difference two columns

### #1 ilovetunics Posted 03 April 2011 - 08:21 PM

ilovetunics

New Member

• Member
• 2 posts
Hello

We run a clothing & jewellery boutique and trying to keep a track of what is selling and stock in hand - therefore want a stock management system

What we have in mind is to stocktake all inventory in store using a barcode scanner say in Column A and doing this regularly once a week – in Column B. We were wondering if there is a formula in open office calc that can find the difference between Column A & Column B and display the difference in Column C so we can check it agains our point of sale and track variances (sold + missing) items

I am using openoffice.org 3.0.0

Many Thanks
Samrat
• 0

### #2 dsenette Posted 04 April 2011 - 07:52 AM

dsenette

Je suis Napoléon!

• 26,023 posts
if column A has the beginning quantity on hand, and column B has the ending quantity on hand, then column C would just need to be =a1-b1 (column A - column B)
• 0

### #3 ilovetunics Posted 09 April 2011 - 10:51 PM

ilovetunics

New Member

• Topic Starter
• Member
• 2 posts
Hi

Let me rephrase it as I know its confusing. The scanned items in Cells will be such as:

1551122
28568686
86895755
8868686
89988585

Also they will be stock taken randomly - therefore if I do A1- B1 = the it will only subtract the difference between them , but what I want is for the spreadsheet to tell me what I have missed out next time I stocktake- so some kind of 'look up' I suppose ..check all barcodes in column A and then compare them agains column B and tell me whats missing

Thanks
Samrat
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users