Hello Excel masters :)
I need your help in order to develop a final file (CustomerForecast) from 3 different files with some restrictions.
The final file should have the below format. The columns "FactType" and "Unit" should have always the same values.
<tbody>
Depot/StoreFormat
Product...
I have a table with Sku and Item Name. There are multiple lines with the same Sku. I want to take this information and create a table showing one line for the sku name and place an "X" with the Item Name that make up the Sku.
Beginning data table
<colgroup><col><col></colgroup><tbody>
SKU...
How do I get to check two cells if they match and then return a value?
I'm using an Id Statement but it's working for 2 out of 3 scenarios.
=IF(A1=B1,1,0)
A1 B1 C1
HAM HAM 0
BEEF BEEF 1
TURKEY TURKEY 1
The If Statement works on BEEF=BEEF and...
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.