Hello Experts,
Attached is the Excel file that I need help with. In the sheet labeled "Changes Jan to Feb" I used a formula to compare the data in "BOM 1" and "BOM 2" to tell me which parts have changed. If possible, I would like a formula for "Changed Only 1" that will fill in columns A-E with only the parts that have changed in "Changes Jan to Feb," but not the ones that read "N/A" or "NEW PART!"
If a better explanation is needed, please ask questions.
Thanks,
Drew
Example.xls
In the Jan to Feb sheet add a helper formula in column F.
At F2 enter:
=IF(D2="CHANGE!",COUNT(F$1
copied down. This cumulatively counts the items with Change in column D
Then your formula in another sheet to get the results would be:
=IFERROR(INDEX('Changes Jan to Feb'!A:A,MATCH(ROWS($A$2:$
copied down and across as far as necessary.