compare between two sheets and shows difference values

abdo meghari

Well-known Member
Joined
Aug 3, 2021
Messages
612
Office Version
  1. 2019
Hi
I want comparing the items in column B for sheet STOCK with columns B:D for sheet REPORT and subtract the values in column C for sheet STOCK from column G for sheet REPORT . if the values in column G for sheet REPORT bigger than values where is existed in column C for sheet STOCK , then should be plus as in column PLUS and should mark wrong as in column MARK , if the values in column G for sheet REPORT smaller, than values where is existed in column C for sheet STOCK , then should be deficit as in column DEFICIT and should mark wrong as in column MARK , if the values in column G for sheet REPORT are equal values where is existed in column C for sheet STOCK then should be hyphen (-) for both columns DEFICIT & PLUS and mark right as in column MARK.finally if there are new items in sheet STOCK but not is existed at all in sheet REPORT , then should be as deficit & highlighted by red and mark wrong as in column MARK .
I put the expected result should be from column F: G in sheet STOCK



report.xlsm
ABC
1ITEMBRANDQTY
21BS 315/80R22 R184 THI10
32BS195R15C R623 THI300
43BS195R15C R623 JAP500
54BS 315/80R22 R184 JAP100
65BS 1200R20 G580 THI-
76BS 1200R24 G580 THI200
87BS 1400R20 18PR VSJ JAP-
98BS 1200R20 G580 JAP120
109BS 315/80R22 R152 JAP-
1110BS 315/80R22 R152 THI-
1211BS1400R20 R180 JAP20
1312BS1400R20 R180BZ JAP10
1413BS11R22.5 R187 JAP22
1514BS 12R22.5 R187 JAP5
STOCK



report.xlsm
ABCDEFG
1ITEMBRANDTYPETYPEARRIVESALEBALANCE
22BS 1200R20G580JAP13010120
33BS 1200R20G580THI--0
44BS 1200R24G580THI190190
55BS 1400R20 18PRVSJJAP12210
66BS195R15CR623THI400100300
77BS195R15CR623JAP5105505
88315/80R22R184JAP100298
99315/80R22R184THI--0
1010315/80R22R152JAP--0
REPORT
Cell Formulas
RangeFormula
G2:G10G2=E2-F2




result
report.xlsm
FGHIJ
1ITEMMARKBRANDDEFICITPLUS
21OBS 315/80R22 R184 THI-10-
32PBS195R15C R623 THI--
43OBS195R15C R623 JAP-5
54OBS 315/80R22 R184 JAP-2-
65PBS 1200R20 G580 THI--
76OBS 1200R24 G580 THI-10-
87OBS 1400R20 18PR VSJ JAP-10
98PBS 1200R20 G580 JAP--
109PBS 315/80R22 R152 JAP--
1110PBS 315/80R22 R152 THI--
1211OBS1400R20 R180 JAP-20-
1312OBS1400R20 R180BZ JAP-10-
1413OBS11R22.5 R187 JAP-22-
1514OBS 12R22.5 R187 JAP-5-
STOCK

attached picture because the XL2BB doesn't allow shows mark right & wrong
1.PNG

also posted here and no answering so far
compare between two sheets and shows difference values
I hope finding here the solution .
thanks
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,223,888
Messages
6,175,207
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top