Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.
Excel Formula Help
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
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
Asked:
3 Solutions
Perhaps try this formula method.
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.
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.
hi..
This can done using VLOOKUP
for more details:
http://superuser.com/questions/541260/find-alike-data-in-two-worksheets-and-put-in-3rd-worksheet
This can done using VLOOKUP
for more details:
http://superuser.com/questions/541260/find-alike-data-in-two-worksheets-and-put-in-3rd-worksheet
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
I'd say, either use VBA for this, or create a hidden sheet that consists of your "Changes Jan to Feb" info, then have a viewable sheet that uses a vlookup to return only those items which have changed.