Jump to content

Welcome to Geeks to Go - Register now for FREE

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
Photo

Finding difference two columns


  • Please log in to reply

#1
ilovetunics

ilovetunics

    New Member

  • Member
  • Pip
  • 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
Edit: Unless you REALLY like getting spam, you should NEVER post your email address in an open forum .
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
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

ilovetunics

    New Member

  • Topic Starter
  • Member
  • Pip
  • 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

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP