Retail Stock Check

So in a store where I work, we don't have that many products about 1700 and we were doing stock check last week, and I devised a much easier method for it.

I exported stock data from our pos software to excel and was left with id. An id of the product, name and how much we should have. So I just added a countif function and we started scanning the products barcodes for ids. The id were just being listed in a seperate sheet while the stock counted itself.
Works like a charm. The only problem was - what if the computer cays we dont have something thus not listing it and we scann it. So that was easy to find - that number would only repeat 1 time in the whole sheet so with count if and if functions it now says error besides the scanned id.

Now i was wondering if there is an easy way to collecting all the errored id's in a seperate sheet. I tried using lookup and vlookup but its not working.

Any tips and ideas appreciated.

Hello welcome to the forum.

If your database is a normal layout of record rows and field columns then you could easily create a Pivot Table on another sheet to filter the 'Errored' records. It could also be done with formulas or VBA, although I'm not sure what capabilities the Mac version of Excel has regarding that.

Perhaps if you could upload a desensitised sample of your data, for the forum members to look at it would help.

DBY

So yeah here is a screenshot of the file im working on.

A - the id nuber of a certain item

B- Name or title of the item

C - number of awalible items imported from the computer

D- Number of things in store ( counted from the scanned id's in column H)

E - If the numbers match it says ok otherwise !!!

H - scanned items

Ignore the K

Screen Shot 2016-10-16 at 19.21.56.png

Yes that is what i wish to do ...

so here is a small sample file

https://www.dropbox.com/s/hao8wd3j38...bexe.xlsx?dl=0

Tried that and it reurns the message completed but nothing happens ...