Have data in columns a, b, c, and d. Want to compare if data in column a = column c. if it does subtract data in c from d. i have 57 lines of data.
thank you for the help.
i need to compare the data in column A to all the range of data in column d and when there is a match subtract the data in cell b with data in cell e. The data column A and column D are the same but in different order. Sorry should have been more clear.
What you're saying is inconsistent with the original post #1. Can you share the item data set with some expected results using XL2BB?
For example,
1) you said you have column A-D. Now you have A-E.
2) you said check if A=C, now it's A=D
Apologize for the confusion. I am having problems with XL2BB. So i am hoping the following picture helps. I would like to compare the data in Column A with the data in Column E. The data is the same but sorted differently. When the data in the cells in column a match column E i would like to subtract the data in Column B from the data in Column F. For example, A3 matches E3 so i would like to subtract 14,460-13,988 and put the answer in column D. hope that makes sense. thank you for your help.
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.