Compare Data

Closed
Report
Posts
3
Registration date
Tuesday December 27, 2016
Status
Member
Last seen
December 27, 2016
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Hello,
I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need to compare the system stock and physical stock. In that time i am facing a problem. So can you guide me for this. In both sheet we have 2 column. One is material code and and another is QTY.




5 replies

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
crazybadri, Good morning.

It's not clear what you want to do.

Do you have two different spreadsheets, one with physical stock and another with system stock?

Explain how you normally do this every month.
I believe that I can help you.
Posts
3
Registration date
Tuesday December 27, 2016
Status
Member
Last seen
December 27, 2016



We have a different material code for each material. This was download data from 2 different system. I need to compare both system QTY. We can not download the the material number serially. So it will be hard to compare 1 by 1. If by the formula we can compare it will be great.
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
crazybadri, Good morning.

You did not say how you want to make this comparison.
This can be done in several ways.

I set a little example for you.
https://www.sendspace.com/file/dxphnp

Sheet1 -> SAP System
Sheet2 -> LCS System

Depending on your image, the numbers were imported as TEXT.
So I set the example just like yours.

Sheet1 ->
Get the material code and search on Sheet2.
If it does not find the code it displays the message:"#ID Not Found"

If you find the material code, then compare the quantity.
If they are the same, the message:"--- ok ---"
If they are not, the quantity found in the LCS System

In Sheet2 the same system was made in relation to Sheet1.

Check if this is what you want.

If you wish, save your spreadsheet to a free website, www.sendspace.com and place the download link here.

So it is easier to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
3
Registration date
Tuesday December 27, 2016
Status
Member
Last seen
December 27, 2016

Hy Good Morning!!!

I want to compare the QTY from the 2 sheet.
https://www.sendspace.com/file/bclq53
Here i had upload the sample excel file. I want compare the QTY from LCS to SAP if there is different in QTY (+ or -) i need to find out this.
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
crazybadri, Good evening.

"...I want compare the QTY from LCS to SAP if there is different in QTY (+ or -) i need to find out this...."

Take a look at your example using same formula that I suggested before.
https://www.sendspace.com/file/s8mvgc

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão